Any help would be very appreciated!!!
I have two tables: Main Data and Archived Data.
Each table has the same fields (about 50 or so fields).
Main data contains records that are updated every week.
Archived data contains historical data that once was in "main data".
Each record can be distinguished by 3 different fields (There is no PK!):Invoice No, Amount, Date.
Some records can be in both tables, some can have the same invoice number (that's why I identify unique record by three different fields). Some can be in the same table with the same Invoice number and so on...
I need to create a form with the following functionality:
1. User enters invoice number.
2. If such record exist and is unique in only one table, then display that record.
if no record found - nothing is displayed
if multiple records exist (either within the same table or different ones) some kind of option should be displayed to specify (or verify) the amount and date to make sure the desired record is displayed.
3. User should be able to modify displayed fields.
The problem I'm having with such design is how to determine how to pull out record from correct table. The design I thought of did NOT seem to be reliable.
Any suggestions will be appreciated and let me know if more info needed about table or data...
Thanks a lot
I have two tables: Main Data and Archived Data.
Each table has the same fields (about 50 or so fields).
Main data contains records that are updated every week.
Archived data contains historical data that once was in "main data".
Each record can be distinguished by 3 different fields (There is no PK!):Invoice No, Amount, Date.
Some records can be in both tables, some can have the same invoice number (that's why I identify unique record by three different fields). Some can be in the same table with the same Invoice number and so on...
I need to create a form with the following functionality:
1. User enters invoice number.
2. If such record exist and is unique in only one table, then display that record.
if no record found - nothing is displayed
if multiple records exist (either within the same table or different ones) some kind of option should be displayed to specify (or verify) the amount and date to make sure the desired record is displayed.
3. User should be able to modify displayed fields.
The problem I'm having with such design is how to determine how to pull out record from correct table. The design I thought of did NOT seem to be reliable.
Any suggestions will be appreciated and let me know if more info needed about table or data...
Thanks a lot
Comment