Problem Inserting Fields from Multiple Tables via Single Form

[Vytas]

Hello,

I'm wondering if the latter is possible in MS Access. Let's say we have
two different tables:

|Categories|
ID (PK)
CategoryName
CategoryFeature

and

|Products|
ID (PK)
CategoryID (FK)
ProductName
ProductFeature

Tables are related using one-to-many relation (see PK/FK). We have a
single form with fields:

ProductName
ProductFeature
CategoryID
CategoryName
CategoryFeature

If we enter a product which already has a related record in Categories
table, there are no problems - we use a drop down list, but how do we
enter a new product name along with a new category using this single
form?

Thanks in advance.

 

[Guest]

You can't do it with that single form. What you will need to do is create a
form for entering products. Then in your combo (drop down), After Update
event, you will need to open the form for entering products. Set the Limit
To List property of your combo to No so it will allow you to enter products
that don't exist.

To see the new product in the list, you will have to requery the combo.