Search results

Pat, again I say it: I have the JobCode links to Items table working fine. The Jobs table (which I use to store JobCodes) only have one column with JobCodes in them. The Items table has a field that contains JobCodes, and they are linked with a one to many relationship. Displaying Items with a...

Alright, so how are you trying to access the table here? Are you using a form? The reasons for your problem are different depending on how you're trying to do things. Ideally, you should upload your database (or a security-safe copy) so that I can have a look directly.

How are you trying to find these fields? Which tables are affected by this? Can you post up the queries/SQL/forms that you're using to find these existing fields?

Pat, that's been done and is working fine. When I navigate to a specific JobCode with the parent form, it displays all items that are tagged with that particular JobCode in the Item record's JobCode field/column. However what I want to do is add existing Items from the Items table by typing...

[Access 2007] Alrighty, gents, thanks in advance for helping me with this problem as I do believe its a little tricky: I have a table "Items" with a text field (DeliveryCode) that is linked in a many-to-one relationship with a table of DeliveryCodes (the only column, as the primary key). The...

Hello from New Zealand! I'm relatively new to Access (only a couple months experience, most of which was spent learning the basics), but I've been working on 'upgrading' databases as a project. Much like being thrown in the deep end, its a very sink-or-swim experience.