Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cross-reference records

Status
Not open for further replies.

Richey

Technical User
Aug 29, 2000
121
GB
Hi

I want to be able to cross-reference records from within one table 'tblactions'

for example lets say the table contains 4 records as follows

ID type area sect_links PAIS_links
1 PAIS Dev
2 PAIS Dev
3 SECT Dev
4 SECT Dev

If someone adds a new record of type PAIS then they can click on button to open a subform which shows ONLY those record of type SECT i.e. 3&4. the user can then say the new record links to one or both of records 3&4
so say they say yes it links to both 3&4 the resulting table would like this

ID type area sect_links PAIS_links
1 PAIS Dev
2 PAIS Dev
3 SECT Dev 5
4 SECT Dev 5
5 PAIS Dev 3;4

also the user may add another record which also links to say record 3, so the table would look like this

ID type area sect_links PAIS_links
1 PAIS Dev
2 PAIS Dev
3 SECT Dev 5;6
4 SECT Dev 5
5 PAIS Dev 3;4
6 PAIS Dev 3

How would I go about doing this please?

Thanks
Connor
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top