Parent Table Link 1

[ZOR]

I have a pair of tables - Parent & Child - Related. Now the user wants to able to create links between chosen parent records. Not sure what the process's would be, although in my mind the records would have a foreign key from another records primary key. Is that correct? Thanks

 

[dhookom]

Could you explain with some examples, table structures, related fields, etc? Usually a parent and child table are linked.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ZOR]

Thanks Duane.

Table 1 - Parent
MasterID (PK)
BarcodeNumber


Table 2 - Child
MasterID (FK)
ChildID (PK)
GAME (Text)


User wants to common a parent record data with other Parent records. Maybee its a junction table required. I have never used them in the past, but now they seem to crop up more than ever. Is this an application for another? Thanks

 

[dhookom]

I am still a bit confused. Does the user want to some how relate one record in Table 1 to another record in Table 1? Does your question have anything to do with Table 2?

I also don't know what you mean by "application for another".

Also, by "explain with some examples" I meant some actual records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ZOR]

Sorry if I wasn't very clear.
The database is a videotape library. The parent records hold barcode numbers and a description of a sports event to which the child records are related to. The child table contains details of individual video clips of that event.

Some tape records are common in some way to each other, for which they want some link placed between parent records. If it was a common field it would be easy, but the user wants some adhoc way of linking records. Hope that explains it a bit more. Thanks

 

[dhookom]

I think you need to create a junction table.

tblMasterJunction
=====================
MastJuncID autonumber primary key
MasterID1 Links to Table 1.MasterID
MasterID2 Links to Table 1.MasterID
JunctionComments



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ZOR]

Many thanks, answered perfectly, have a star. Regards