By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Database Dilemma

P: n/a
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

Mar 19 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Mar 19 '07 #2

P: n/a
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

Mar 20 '07 #3

P: n/a
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
Mar 20 '07 #4

P: n/a
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
Mar 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.