Concatenation of five fields and use to build relationship

[prestopr66]

Hi Isladogs
Ok its now coming together. The intent of the concatenated field was for the user to select from a combo/box or list. But I don't see how this can be done in the form! Your help is appreciated

[prestopr66]

Hello
I have created the form but it wont accept new records. When I try and enter a record the following message appears in the bottom bar. "Cannot add records. Join key of table DAT_PROD not in recordset"

[isladogs]

Suggest you upload a zipped copy of your database removing any confidential data as its difficult to follow what you are doing and what is happening

[prestopr66]

Hello

I have hit a brick wall!

Find attached a copy of my database I'm currently working on.
Completed so far;
1. Created query to combine two tables
2. Created form with concatenated field called GCOB_identifier (combobox) to allow for data entry.

ideally once the user selects a GCOB_identifier from the Combobox the design tonnes and grade would then populate.
Unfortunately, the current form wont accept new records and cant work out how to get GCOB_identifier working as I want it to.

Thanks

[orange]

I recommend you give a plain English description of the application this database is intended to support. That is - what is the business you are supporting with this automation? I see equipment and haulage, but not the overall process.
Good luck with your project.

[ArviLaanemets]

A simple example of possible solution

Edit: I forgot to create an unique index for tblItems based on 5 item names. You can create it yourself!