Link to home
Create AccountLog in
Avatar of duta
duta

asked on

Access 2007: Relational Database Tables

Dear experts:

Hi again!

I have a couple of questions regarding creating a relational database.
I created one, but it is incomplete by all means.

First question: Assume that I have two tables (one to Many); The many-side table has a foreign key which is the primary key in another table.
I established relationship between them and integrity constraint.

I first filled the one-side table with data. Then I filled the many-side table.
I thought that when I filled the foreign-key attribute in the many-side table, a dropdown menu (which displays all the input of the attribute in the one-side table was supposed to show up.  But it did not.

My question is: How to make the dropdown menu displayed?

My second question is related to the table below:

cash#    part#     Part_unit_price       qty_ordered   total_amount

Total_amount refers to the product of part_unit_price and qty_ordered.

How to coduct the product operation in access?

Thanks a lot!

duta
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

'a dropdown menu (which displays all the input of the attribute in the one-side table was supposed to show up.  But it did not.'

Guessing at what you mean here, but if you are referring to the subdatasheet feature, it works the opposite way round to this.
You will get the + on the 'one' table and clicking it will show the related 'many records.


Avatar of duta
duta

ASKER

Dear peter:

Thank you so much for your kind, superprompt response.

In fact, I made a mistake in describing what I did: I already put the PK in many-side table in the one-side table.

Thanks!

I don't know what your question is, then.
Avatar of duta

ASKER




TO: Peter:

You wrote: if you are referring to the subdatasheet feature, it works the opposite way round to this.
You will get the + on the 'one' table and clicking it will show the related 'many records.

MY QUESTION:  How to activate "subdatasheet feature"?  

Thanks again!

duta
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of duta

ASKER

TO: peter:

Thank you so much for your kind, prompt response.

You wrote: Otherwise you can set a subdatasheet by displaying the table properties and choosing the related table in the subdatasheet property drop down list.

MY COMMENT: Can you give me a ste-by-step instruction to do that?

Thanks a lot!

duta
Open the table in design view.
Choose View>properties from the menu.
In the subdatasheet property choose the table.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of duta

ASKER

TO: DatabaseMx:

Thank you so much for your kind tip.

I will take itme to read the tip and come back to you.

Thanks!

duta