Search results
-
S
When 1 records "relates" to another in same table
Great, this is what I hoped was possible and yes those aliases are important. Thanks- skissh
- Post #3
- Forum: Theory and practice of database design
-
S
When 1 records "relates" to another in same table
When 1 record "relates" to another in same table I have come upon this situation before. I imagine it is not uncommon and I don't know if there is a vetted solution. How do you connect these two records so that when a query that gets a hit on one record, the other record is also available for...- skissh
- Thread
- Replies: 2
- Forum: Theory and practice of database design
-
S
Combining records to make new table
Thanks to the suggestions of Wazz and MagicMan I implemented a solution that worked. Here is what I did. 1. Added these fields to original table. Valve Manuf (field 1 I needed from another record) Valve Model (field 2 I needed from another record) ValveID (foreign key from the duplicate table)... -
S
Combining records to make new table
I will receive a single table, with no relationships, from a coworker containing data that will not be changed. The table will be used to create report sheets that need to be filled out by hand. Currently each sheet will require information from 2 records in the table but it is not a summary. I...