Recent content by mike60smart

Hi It would help us understand if you gave us examples of actual "Stats" rather than a list of Stat1 through to Stat30

Hi If you want to be able to choose a Supervisor , then allocate a Shift and then allocate Employees to the Shift selected, then you need tables as shown in the attached screenshots. The Data Input Form allows you to select a Supervisor, Select the Shift he is responsible for and then add...

Hi If I create a Form which allows you to select a Tag what data would you then want to be able to add? The attached screenshot allows me to select a Tag, and then add details about a specific Level Transmitter and Pressure Transducer associated with the Tag selected.

From the Relationship diagram it is difficult to determine what in fact you need to do. Do you want to be able to Select a Tag and then enter details of the Pressure Transducer as well as details of the Level Transmitter?

Are you able to upload a copy of your actual database?

Hi So all 3 rows belong to 1 peice of Machinary?

Have you an example in Excel of 1 Piece of machinery with all associated Parts?

Hi Are you able to upload a screenshot of your table relationships?

Can you upload a copy of the database with no confidential data?

This just confirms that your table structure is all wrong.

Hi Bob Well Gasman gave you the solution as to how you can achieve this. All I am trying to do is point out that the structure of the Subform is wrong.

Hi Gasman Yes "Paid" would also be included but difficult to determine as we have no idea of the actual table structure.

So the Subform for entering Invoice Number information must be based on a query based on Multiple Tables. The Subform has Multiple Redundant Controls because all you actually need to enter in the Subform is the "Date", "Invoice Number" & "Amount"

Can you upload a screenshot of your Form in Design View?

Attached is the screenshot of your tables. I do not see a table named "RDCMaterialT" ??