Table structure or something else?

[Becky]

I am making a configurator. I have the main table as

tblConfigurator:ConfiguratorID, AuditID, SystemID,
ChamberAID, ChamberBID, GasPanelAID, GasPanelBID

The default value is 0 and I stated that it isn't
mandatory to have a field value.

The other six tables only have a primary key (above
mentioned) and then their fields.

I have a six page tabled form to save the data using a
query that uses * tblName to join all the tables together.

What happens is that it wants a value for each ID or it
will not save. Chamber B may not have any data.

What am I missing here?

Thanks,
Becky

 

[Michel Walsh]

Hi,


Make the data required (no null allowed) in the six ID fields (all except
ChamberDIB) at table design.


Hoping it may help,
Vanderghast, Access MVP

 

[Chadlon]

Becky,

If you have Referential Integrity active for all of the relationships, but
one or some of the Foreign Keys may be redundant or irrelevant in a
particular case, then best not have the FK default to 0.

Usually, you can "get around" R.I. if the FK is left Null. Setting it to
zero causes RI to kick in and look for a Primary Key with value 0 - which
you most likely don't have.

CD

 

[Marshall Smith]

I think the basic problem is that you are joining all the tables together.
I think you would get the result you want from subforms. The subforms do
not require records to be present. Simply use your various ID fields as the
link fields, and you should be good to go.

As a follow-up suggestion, it might be worthwhile to put each subform on a
different tab in a tab control. It makes for a much more efficient use of
screen space.

HTH,

Marshall Smith
Project Developers, Inc.