aussieolie
Australian
- Local time
- Today, 13:33
- Joined
- Apr 3, 2002
- Messages
- 47
I am a high school student who is creating a database for my final work and I am completly stuck.
I cannot understand what to do now I have normalised a table. I need all the information to be displayed on a form, do i need to create seperate tables?
Also i am trying to create a invoice (as a report) from multiple tables, so far I have made a make table query which produces the table, however it wont let me put more than one autonumber fields from other tables in. As i need to put in 3 auto number fields (Stock ID, Manufacturer ID, and Sale ID) eventurelly it should produce a invoice for each page.
If anyone could please help me, i can send the database. My email address is aussieolie@yahoo.com
I cannot understand what to do now I have normalised a table. I need all the information to be displayed on a form, do i need to create seperate tables?
Also i am trying to create a invoice (as a report) from multiple tables, so far I have made a make table query which produces the table, however it wont let me put more than one autonumber fields from other tables in. As i need to put in 3 auto number fields (Stock ID, Manufacturer ID, and Sale ID) eventurelly it should produce a invoice for each page.
If anyone could please help me, i can send the database. My email address is aussieolie@yahoo.com