Access form building
March 3, 2006 10:26 PM Subscribe
MS Access XP: Say I have 3 tables.
posted by bigmusic to Computers & Internet (12 answers total)
I'm trying to migrate from an excel spreadsheet(s) to a database and my boss wants me to use access. But he's asking me something that I don't know how to do yet. I know it's probably something simple, but I'm having problems here.
Table.Customers with the fields:
CustomerID | CustomerName* | CustomerAddress | CustomerEmail |
Table.Projects with the fields:
ProjectID | ProjectLocation* | ProjectDetail1 | ProjectNote |
Table.Reports with the fields:
ReportID | ReportName* | CustomerID | ReportID | ProjectID | ReportStatus1 | ReportStatus2 | ReportStatus3 |
How do I get a form to display ReportName | CustomerName | CustomerEmail | ProjectLocation | ProjectNote | ReportStatus1 | ReportStatus2 | ReportStatus3 |
Where CustomerName and ProjectLocation can be selected with dropdown boxes, and not editable so that CustomerEmail and ProjectNote show the fields related -- which are also not editable. Everything else would be editable.
The lookup wizard doesn't seem to do what I want it to do for this. I have a sneaking suspicion that it has something to do with a query and a form.
Also are there any websites/communities devoted to this kinda thing?