Hi there, i am coming from a Filemaker background, not extensive but Filemaker nonetheless. I have decided to move a project I am working on to Access. I have a database that tracks a logging operation (forestry). Main focus on the application is tracking the contactors, loads hauled, skidded, cut, or processed. Designed basically as in invoice application with a forestry swing on it.
I select the contractor and begin entering in this case, the load information in the line items table. The line items table is linked by a multi-predicate join to select the rate of pay. 3 fields determine the rate of pay. I Enter the info including the source, destination. The Class filed is a hidden calculated field that is created on creation of the new record set by and Contractor Pay Type field (master record). See pics
In my rates table i have fields (RateID, Block, Destination, Class, Unit_of_Pay and Rate). Rates are different for each class, being LOAD, CUT, Skid, Process, and Slash
So three conditions have to be met before the correct rate will be selected. Now to Access, I would like to have my rate auto-populate in my loads table on each record when entering but cannot seem to see how. I want to setup a calculated field that concatenates the three fields in question, and use that in a foreign key to the rates table and do the same in the rates table with a concatenated field with the three fields as a primary key. Is this possible. And I apologize for the long post.