Hi, im a bit stuck as im new to learning access.
I have a basic form based on a table.
My form is a sub assembly of a Part
in the form you can add a task and minutes.
I have another table that has Rates, Labour markups etc. but not related to the Sub assembly.
I am trying to get the sub assembly form to include the Rates so it will calculate the labour costs.
But i dont want to for every new sub assembly i create have to select the labour rates, i just want it to look up the current rate from the rate table.
I hope i made sense and someone might be kind enough to help out :)