Jump to content
Salesforce and other SMB Solutions are coming soon. ×

relationships


lansdowne
 Share

Recommended Posts

I have my tables all sorted, updating from Excel and they work fine. I've done my relationship graph but as much as I read up about them I stil don't really know if I have got it right or not.

my tables are as below:

 

[TABLE=class: cms_table]

[TR]

[TD=class: cms_table_xl63] FMRESULTS[/TD]

[TD=class: cms_table_xl64][/TD]

[TD=class: cms_table_xl63]FMRACES[/TD]

[TD=class: cms_table_xl64][/TD]

[TD=class: cms_table_xl63, width: 110]FMCOURSE[/TD]

[TD=class: cms_table_xl64, width: 19][/TD]

[TD=class: cms_table_xl63, width: 110]FMHORSES[/TD]

[TD=class: cms_table_xl64, width: 19][/TD]

[TD=class: cms_table_xl63, width: 110]FMDECS[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl65]_fkfmcourseID[/TD]

[TD][/TD]

[TD=class: cms_table_xl65]__pkfmracesID[/TD]

[TD][/TD]

[TD=class: cms_table_xl65]__pkfmcourseID[/TD]

[TD][/TD]

[TD=class: cms_table_xl65]__pkfmhorsesID[/TD]

[TD][/TD]

[TD=class: cms_table_xl65]__pkfmdecsID[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl65]_fkfmhorsesID[/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl65]_fkfmracesID[/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[TD][/TD]

[TD=class: cms_table_xl66][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Course[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Race_no[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]CourseID[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]horseID[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]race_id[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Type[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Course[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Course[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Horse[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]No.Drw[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Rdate[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Type[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Horse[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Rtime[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Rdate[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Wgt[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Going[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Rtime[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD=class: cms_table_xl66]OHM[/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Age[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Go[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Furs[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Age[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Class[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Furs[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Ran[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]Class[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Pos[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]GRD[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Drw[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]WA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Btn[/TD]

[TD][/TD]

[TD=class: cms_table_xl66]AA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]TBtn[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Horse[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]Wgt[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]OR[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]GRD[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]WA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: cms_table_xl67]AA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[/TABLE]

 

 

As you can see in the results table it doesn't have a primary key, but has three foreign keys is that o.k.?

 

eventually I want to be able to loop the horses racing on that particular day in the FMdecs

table and get the form from the fmresults table then display all runs in rating order if that is poss.

 

Davey H

Link to comment
Share on other sites

The relationships look OK.

 

DO be aware that just because you have a relationship between Table A and Table B, that doesn't cause a new related record to spring into existence in Table B as soon as there is a Table A record.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use