Search results

Just a comment. A lot of your Tables contain Lookup Fields. You should not use Lookup Fields in tables. Google "The Evils of Lookup Fields in Access Tables"

Can you upload a stripped down version of the database with just the tables and query?

Hi John Your tables/Relationships should be as shown in the attached.

yes thanks

If you don't mind me asking but what is the point of this as an Access Database?

Hi I believe you need to have a rethink on the structure of your tables. The attached is an example Relationship Diagram produced by Github. See this Link

Hi Barbara The database you uploaded has a table named "Investments01_tbl" with 18 Records. The other related table named "Investments01_tbl_SubForm" has over 24000 Records. We need the original "Investments01_tbl" with all current records. Also the Form with the error is based on a Query? The...

No it is not. The process is that you click the Reply button and enter your answer. Then click the "Attach Files" button and navigate to the database file you want to upload. Make sure that you compress the file into a zipped format. Then select the compressed/zipped file and click Open. The...

Hi Barbara No attachment

Hi Barbara Can you upload the Db so we can see the problem?

True, badly worded on my part. Probably best to say that you cannot set the relationship unless bad data is removed.

True but the purpose of the Post was to indicate to the OP what the error was.

Hi Attached is a screenshot of what I think are the required Relationships. Not all tables are as yet included.

Hi Can you send me your current "tblMachine" with actual data?

When you talk about Machine ID 312 and 1046, are these ID numbers that have been Manually created by you?

No it makes complete sense

Hi You must have a specific List of PayRangeDevices which are installed into a specific Machine. Then depending on circumstances the Device has to be removed from 1 machine and placed into another. Can you give me an example list of current PayRangeDevices?

Hi Can you give me an example list of the "PayRangePin" you use ?

OK but your current tblMachineInventory does not even have a field for MachineID ?

Hi What specific details do you record about a Machine? Do you have specific Serial Numbers or other details other than a MachineID ?