Getting Form Data discplayed from One Table Into Another Table

[CharlesWh]

New to Access! I am creating a quotation database where a new company name will be entered. In 1 form a pick list of products which I then want to go into another table associated to the company name which can then be queried and displayed in a report for printing the quotation.

I have created

QuotesTbl
QuoteID (PK)

QuotedItemsTbl(PK)
QuoteID (FK) (1-Many Relationship w/above)

I will create a form to generate a new quote, enter the company name with a display of quoted items (QuotedItemsTbl) (Query QuoteID).

On that Form i want to have a button to 'add items' on that form be able to pick from items in StockTbl which when selected and button 'close' copy the data to QuotedItemsTbl

Any advice to a enthusiastic buy novice newbie much appriciated.

 

[carash77ash]

i know exactly what you are after, have nearly completed a similar project.

It is not as simple as it seems.

You need to think about what you want as i have some 12 tables in my project. Set out a plan of the specific data that you want to show. and then design tables around that data.

My tables and relationships is attached.



Ash

 

[CharlesWh]

Reply

Thanks for the info. I seem tobe working form the opposite end, I know what I want and working on develpoping the knowledge as i go along. thankx though.