Show all from one table and select

[Gismo]

Hi all, please help.
I have a table with customers and a table with inventory, no relationship between the 2. I created a 3rd table with customer, item and a yes/no field.
I need a form there I could select a customer, see all the records in the inventory table and then I want to select only the records from inventory that is applicable to the specific customer.

How do I go about? relationships created between the three tables, tried outer join, then I could not select yes/no.

Selected inventory and customer name must be saved to 3rd table

 

[CJ_London]

take a look at this link - you will need to modify the code to create the records in the third table

https://www.access-programmers.co.uk/forums/showthread.php?t=289116

 

[Gismo]

Thank you CJ, I had a quick look at your link, looks quite complicated for my knowledge, will study it further.

 

[Gismo]

Does anyone know if you can add options for a combobox without having to create a table for it? For example a currancy table with only 2 records, that will be a waste of space and unnecessary tables for just 2 records

 

[plog]

You can hardcode a combo box with values. Row Source Type = Value List, then you add your values in the Row Source property. Of course if there's just 2, a Yes/No might be a better option.

 

[jdraw]

Gismo,

Can you tell readers in plain English (as you would use to explain to an 8 yr old) WHAT you are trying to achieve. You are telling us about forms, combobox and yes/no fields that are part of the HOW you see as a solution. But for communications and context we need to focus on WHAT, then we can deal with how.

Good luck.

 

[missinglinq]

In version 2007 or later, with the Combobox selected

Go to Properties – Data and set the Limit to List Property to Yes

Now, in Form View, simply add the new item in the Combobox

When you move to another Control, a Dialog Box will pop up, saying

The text you entered isn't an item in the list.
Do you want to edit the items in the list?

Click Yes and another window will pop up, with the new item entered highlighted.

Click OK and it's now part of the list!

Linq ;0)>