Best Way to Enter Duplicate Records (-1Field Different)

[Kiko0423]

Hello All,

I have searched this topic throughout the web and cannot seem to find a clear answer so I thought I would post this here.

I would like to know what the best way to input a duplicate record is with the exception of 1 field that is used to correspond with the proper parent of the record?

Here is an example of the problem,
We receive a letter with pertinent information that corresponds to 30 of our facilities. I would need to enter this 30 times so that when the users of this information run their reports for their facility I can ensure that the letter would be referenced.

Let me know what you think is best!

Thanks for the assistance
Kiko

 

[JHB]

Here is an example of the problem,
We receive a letter with pertinent information that corresponds to 30 of our facilities. I would need to enter this 30 times so that when the users of this information run their reports for their facility I can ensure that the letter would be referenced.

Can't you create a table, (linked to the particular letter), which hold the facilities a letter corresponds to?

 

[jdraw]

You have a data structure problem - perhaps your tables or relationships - do no support your business.

You need to relate Letter to Facility.

Also -- duplicates have all fields equal.

 

[EternalMyrtle]

Your question is not completely clear: are you trying to add the actual letter to 30 records (if so, you probably have a data structure issue) or are you trying to enter the info from the letter into a form once and create duplicate records for the 29 remaining facilties?

If you are trying to do the latter, one problem I see is that you would likely already have records created for all 30 facilities. Duplicate records work best for new records not for existing records.

An update query would probably work best.