Primary key recognition

Hi there,

In our database we have quarter and year information in many tables/ forms. These are built from combo boxes. The quarter and year fields are often part of the group of primary keys for our tables.


On our main switchboard is a combo box for year, and one for quarter. In the database I’ve managed to set up all the quarter and year fields to correspond to whatever is entered into the quarter and year combo boxes on the main switchboard. So where this is set for Q1, 2019 the same appears in all the other forms.

From the year / quarter combo box properties I used the expression builder (properties, data, control source) to look up the part of the switchboard to pull the info through from, in this case:

=[Forms]![frmSwitchboard]![Combo20]

Where Combo20 is the drop down for the year. The correct information appears in the forms nicely.

However…

The quarter and year fields form parts of the primary keys.

When entering data the forms seems to read the year and quarter as blank, thus won’t let the record be saved (because primary key information is incomplete). They aren’t blank, nor incomplete but rather the information pulled through isn’t being recognised.

I’ve tried a few things with no luck…

Any help grately appreciated! My deadline to share the database is tomorrow so not long to work this out :)

Tom