Beginner trying to create a database

[Hottest Fudge]

Hi Mile-O,

Wow, thank you very much! Now to break it a few times and try figure out how it works!

Many thanks,

Hottest Fudge

 

[Mile-O]

I'll give you some clues:

1. Table design. I modelled your many-to-many relationship between substances and health risks via a junction table.

2. A subform (in data sheet view) bound to the junction table, and placed on the form bound to the substances table.

3. Linking between the form and subform via parent/child fields. It's all in the properties.

 

[RainLover]

Mile-O

Could you explain something to me which I have never seen before.

With Combos I usually put the primary as the first Column with a width of Zero. The other Columns follow with individual spacing like 2.0 or 2.5 etc.

You don't appear to have done this. It looks like everything is auto.

Am I understanding this correctly.

 

[Mile-O]

Mile-O

Could you explain something to me which I have never seen before.

With Combos I usually put the primary as the first Column with a width of Zero. The other Columns follow with individual spacing like 2.0 or 2.5 etc.

You don't appear to have done this. It looks like everything is auto.

Am I understanding this correctly.

If there's only two columns and one's a primary key that I want hidden, I only enter a zero for the first column, which will be its width. Beyond that Access autos everything else. Since it's only visible column, I'm not interested in defining its width as it will adjust to the whole of the combo anyway.

Through personal choice, I never use more than one visible column in a combobox. If it was a case where I was hiding extra information on a four column combo, I'd still have 0;2cm;0;0.

 

[RainLover]

If there's only two columns and one's a primary key that I want hidden, I only enter a zero for the first column, which will be its width. Beyond that Access autos everything else. Since it's only visible column, I'm not interested in defining its width as it will adjust to the whole of the combo anyway.

Through personal choice, I never use more than one visible column in a combobox. If it was a case where I was hiding extra information on a four column combo, I'd still have 0;2cm;0;0.

Thanks for that. Clear and understood.

So simple. However it is amazing how often one learns something new just by helping out.