I'm creating a database and I would like to include an OR statement in the field linking.
I have two fields that work together as being unique, so the AND (read: semicolon) works great in that sense. I would also like to include records that match another field aswell.
I successfully did this using QBF with a stored procedure, however I was unable to insert new records.
Table Layouts:
Cable Records: Cable, Pair, ..., Local, ...
SR/TT Junction: SR/TT, ..., Cable, Pair, Local, ...
SR/TT: SR/TT, Time, Date, Remarks, Pers
I have SR/TT and SR/TT Junction joined in the subform and am looking to link the (Cable and Pair) or Local fields with Cable Records to eliminate the need for a form to show each field link.
I am using a datasheet and it won't let me use multiple subforms.
Using:
MS ACCESS 2003
MS SQL Server 2000
Has anyone done something similar to this?
Thanks,
Banks.
I have two fields that work together as being unique, so the AND (read: semicolon) works great in that sense. I would also like to include records that match another field aswell.
I successfully did this using QBF with a stored procedure, however I was unable to insert new records.
Table Layouts:
Cable Records: Cable, Pair, ..., Local, ...
SR/TT Junction: SR/TT, ..., Cable, Pair, Local, ...
SR/TT: SR/TT, Time, Date, Remarks, Pers
I have SR/TT and SR/TT Junction joined in the subform and am looking to link the (Cable and Pair) or Local fields with Cable Records to eliminate the need for a form to show each field link.
I am using a datasheet and it won't let me use multiple subforms.
Using:
MS ACCESS 2003
MS SQL Server 2000
Has anyone done something similar to this?
Thanks,
Banks.