Display related records from another table?

[DB88]

I learned database design using FileMaker but my new company only has Access so I'm trying to learn. I built a one-to-many relationship between Platform (one) to Features (many) using the table LineItems. To set up the relationship, both Platform and Features have primary keys. Then each record in LineItem contains two foriegn keys, one denoting the Platform and one denoting the Feature. I didn't use Lookup because that appears to only work for One-to-One relationships.

To start I want to just view the features associated with a specific platform in a form. I tried a list box, a subform and a combo box. Each one would show ALL records from Features not just those related to the specific platform record. What am I doing wrong?

Once I solve that problem, I would like to be able to create LineItem records from the Platform form.



Note: If you are familiar with FileMaker, I'm trying to get the functionality of a portal

[SideQuestion: why does the lookup wizard create a new relationship/new table in relationship view everytime, even when the necessary relationship is already established?]

[June7]

The listbox, subform, combobox must be filtered.

Subform container control has Master/Child Links properties that will synchronize main/sub form records.

Options for data entry/edit form:

1. one form bound to LineItems with two comboboxes to select platform and feature

2. main form bound to Platform and subform bound to LineItems with combobox to select feature

3. main form bound to Features and subform bound to LineItems with combobox to select platform


Don't know about lookup wizard, don't use it, I avoid most of the wizards because they do stuff I don't like. I NEVER set lookups in table.

Why do you think lookup works only for 1-to-1 relationship?

[DB88]

Thanks! Now I can view the associated Features records.

How do I set it up so that a user could add specific features to a platform record from the Main Platform form? For example a platform can have a combination of 10 features. When I add a new platform, I want to also select from drop down list the x number of features. How do I set it up so that I create a new LineItem record using LineItem subform and select the associated feature (without just typing in feature primary key)?

[June7]

Option 2 form/subform. Multi-column combobox. Review http://www.datapigtechnologies.com/f...combobox3.html

[DB88]

Thanks!! I got it.