wallis1905
Registered User.
- Local time
- Today, 16:07
- Joined
- Mar 13, 2007
- Messages
- 46
Autonum PK problem?
Ok I'm changing the primary key for a start
Quote
Now base your instrumentation tables on that starting point. You might have one table for each TYPE of instrument. This relationship would then be SPARSE in the sense that over the sum of all instrument sub-tables, you would fully reference every instrument at your complex, but no instrument would appear in two sub-tables at once.
Hi again. Can you tell me if you would use autonumber to form the relationship in each case? I have tried to do this and it works good bar one problem. The link seems to be good and the secondary table gets populated as intended. However, because the autonum value for a record in the main table will be different than that of its counterpart in the secondary table. This means that when I try to view a record through a query(ie some fields from the main table and all fields from the secondary table) I see nothing. The join properties filter out all the records. Obviously if the ID numbers matched it would be ok. Am I being silly?
Ok I'm changing the primary key for a start
Quote
Now base your instrumentation tables on that starting point. You might have one table for each TYPE of instrument. This relationship would then be SPARSE in the sense that over the sum of all instrument sub-tables, you would fully reference every instrument at your complex, but no instrument would appear in two sub-tables at once.
Hi again. Can you tell me if you would use autonumber to form the relationship in each case? I have tried to do this and it works good bar one problem. The link seems to be good and the secondary table gets populated as intended. However, because the autonum value for a record in the main table will be different than that of its counterpart in the secondary table. This means that when I try to view a record through a query(ie some fields from the main table and all fields from the secondary table) I see nothing. The join properties filter out all the records. Obviously if the ID numbers matched it would be ok. Am I being silly?