Link Records

[SuddathAL]

I am building a DB to track moved orders for a logistics company. Sometimes the orders travel alone and sometimes they travel together, sharing expenses. Is there a way to group or link records that travel together so that all of the financial data can be pulled for the entire movement, not just each order?

i am thinking that i can make a table that has "container number" and "pick up date" with an auto number as the primary key. Then use this number as a "Move number" as a foreighn key in my main order info table.

any comments are appreciated.

 

[Montez659]

Without getting into the major logistics of it, a simple junction table would work. There would be three fields - the autonumber as a PK, and two FK's. The first FK would be the "grouping" number - you would somehow have to find a way to assign a new grouping number. The second number would be the record ID's that you want to group.

Then, any reports that you need to run you would be able to query all that were associated with a grouping number and get the info that you need combined.

This is the theory of it, and not the functioning logistics of pulling it off. Probably would need a few extra forms to group records together, or commandbutton or checkbox or something on the form to indicate that it is grouped and some way to identify how it is grouped.

It sounds like from the way that you write that you have a decent handle on Access so I didn't include any of that other stuff, but I will be happy to go into further detail if need be.

 

[SuddathAL]

thanks for the fast reply. I had not thought of doing it that way. I may be overthinking it, trying to get everything on one form.