Combobox control for linked form/subform

[Dbusse706]

Hello! I'm new to access and I'm trying creating a database to keep track of issues which require follow up for a retail store. I can get everything I want to work done alone, but when trying to combine elements together I'm running into some issues.



I have 3 tables. Here are the important parts of each.

DivisionNumber*	PogID**	FollowUpID
DivisionDescription	PogLead	PogID**
	PogDivision*
	PogUnique
	PogDescription
*1 Division Num can have many Pogs	**Each POG can have many follow up items	(A Pog is a blueprint to set an aisle)

Each POG has a unique POG number which is the combination of PogLead+PogDivision+PogUnique. (ex: A-049-APL).
I originally stored the 3 fields together as PogNumber for my primary key, but to follow rules of normalization I broke it down since a Pog Division number will always have the same description. This is where the problems started coming in!

What I want my form to look like is:

ComboBox in header where I can type in a POG number to jump to the appropriate record.

Pog Information in the detail section

Follow up information in a sub form

Right now I can either have a form/subform working together but an unusable combo box (when I create the combobox the 3rd option for it to find a record is not listed and I have not found the way to get this to work properly), or I have a combo box that works with the main form but the sub form shows all records of the issue table, not the ones just relating to the corresponding PogID.

Another part of the problem is I assume I will need to create the forms from a query since I want to be able to type in the Pog Number in the combobox which would be a calculated field (poglead+division+unique), but when I use a query for my form it will display a separate Pog record for each follow up issue.


Does the way I explained this issue make sense and is the a way to overcome it for a beginner/intermediate level user? If combo boxes don't work like this would I be able to put in a text field in the header and macro a button to find the record that matches the fields?

If there's not simple solution I will just forget normalization until I got better acquainted with Access and go back to using the Pog Number as my primary key and type in the description for each record since I had everything else working at that point.


Thanks!

[June7]

Each Division can have many POGs and each POG can have many FollowUps?

Are you using Master/Child links properties of the subform container control to synchronize the related records?

The unbound combobox should funtion to locate POG record.

[Dbusse706]

Awesome! linking the tables in combination with putting a unique value filter on my combo box has done the trick. I guess I assumed Access would know how to automatically set the parent/master.

Sorry about the confusion around the notes Each Division can have many POGs and each POG can have many Follow ups. I was describing the one to many relationships between tables in case that information was relevant.

Thank you for the quick and accurate response!