Building solid foundation

[JulieFall]

Somewhat familar with Access here <-------- Be Gentle small words

I probally could Mickey Mouse this, but I really want to to function correctly!!

Main use for database is using forms and creating reports to monitor trends. Defective Material Form is always filled out first, on the disposition part of form there are choices, Corrective Action, Vendor Corrective Action or Customer Acceptance of Deviation. When one of the dispositions is selected I would like that form to open and all the liked information to fill in automatically. Do I make the fields look-up's or shoud I make queries?

This is just a start of my questions..... got may orphan ideas, just want to make a happy family

Thanks in advance

Julie

 

[WayneRyan]

Julie,

That is a very general question.

You will want to make use of combo-boxes (driven by tables) and
avoid storing the same info in more than one place.

Your other forms, can be subforms and they can be mapped
to separate tables. If possible, they can have certain fields
in common like status, date completed, etc. Then you can
do queries easier.

Feel free to post here with specifics as you progress.

Wayne

 

[jon98548]

I think too, in some cases, you're going to need to learn about DLookup for those things you want to 'autopopulate' (good search term).