Database Dilemma

[Dr.Dre4eva]

I'm having some access problems that perhaps you could help me with.
For a school project I am required to create a database package for a
company. The company I chose was late in supplying some very vital
information so I am now behind in the database development and I find
it hard to over come certain obstacles.

1) When using auto numbers in one table should a related table use
auto numbers for that field as well?

2) When using Auto- Numbers what process should be used when adding
records through a form so all the tables containing similar fields are
updated

3) Is there anyway to filter a form's results?
Respectfully,
Andre Browne

[Allen Browne]

Replies embedded.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Dr********@gmail.comwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...

I'm having some access problems that perhaps you could help me with.
For a school project I am required to create a database package for a
company. The company I chose was late in supplying some very vital
information so I am now behind in the database development and I find
it hard to over come certain obstacles.

1) When using auto numbers in one table should a related table use
auto numbers for that field as well?

No. The related table uses a field of the same type and size.
To match an AutoNumber, use a Number of size Long Integer.

2) When using Auto- Numbers what process should be used when adding
records through a form so all the tables containing similar fields are
updated

AutoNumbers don't change, so you do not need to alter the foreign keys that
relate to the autonumber.

3) Is there anyway to filter a form's results?

Many ways:
- Filter By Selection (toobar button)
- Filter By Form (toolbar button)
- Click Filter on the Records menu for more options.
- Right-click a control on a form to filter.
- Apply a filter programmatically.

I'm guessing you don't want to program it for a school project, but if you
do, here's a few examples:
http://allenbrowne.com/casu-15.html
http://allenbrowne.com/casu-08.html
http://allenbrowne.com/AppFindAsUType.html
http://allenbrowne.com/ser-62.html

[Dr.Dre4eva]

Thank you, this data was very helpful (particularly that info on your
site). I have one last question. Is there anyway to restrict the
values in a combo box. For example; Each good is given a
classification, however many goods may have the same classification,
but i do not want the same classification to be repeated in the combo
box

Respectfully (almost joyfully) :),
Andre Browne

[Allen Browne]

You are suggesting a many-to-many relation where one item can belong to many
classifications, and one classification can apply to many items.

You need 3 tables to model that: on for items, one for classifications, and
one for the junction of the two (combinations of ItemID + ClassificationID.)

Once you have that structure in place, the primary key of the junction table
becomes the bound column of the combo.

(A combo has only one bound column, so it might be best not to use a
compound key for the junction table.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Dr********@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

Thank you, this data was very helpful (particularly that info on your
site). I have one last question. Is there anyway to restrict the
values in a combo box. For example; Each good is given a
classification, however many goods may have the same classification,
but i do not want the same classification to be repeated in the combo
box

Respectfully (almost joyfully) :),
Andre Browne

[rkc]

Dr********@gmail.com wrote:

Thank you, this data was very helpful (particularly that info on your
site). I have one last question. Is there anyway to restrict the
values in a combo box. For example; Each good is given a
classification, however many goods may have the same classification,
but i do not want the same classification to be repeated in the combo
box

Set the recordsource of your combobox to a query instead of a table and
use the distinct keyword.

SELECT Distinct Classification From TheGoodsTable