I'm trying to create a database layout proposal, and am having a hard time remembering how to forumlate something for the following:
3 Sheets
- the first is the quote (basic structure: section #, item, qty, item cost, cost)
- the second is details about the items (section #, item, description)
- the third is for our eyes only, and contains the data for the drop-down menu on the first page with the items along with the description
On the 3rd sheet I have put a description of each item. So it would say "Hockey" and in the next cell "Ice Hockey is a sport played on ice"
The problem I'm having is finding a way to auto complete the description on sheet 2 based on the item selected from the drop down menu on the first sheet.
Hope this makes sense, any clarification needed, let me know. ANY help is much appreciated.
![]()
Bookmarks