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
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