I am new to Access. I know the very basics. For my work I need to create a database that search for any keyword to retrieve records. I have 4 tables. A SITE table with file number, address, description, TMS # and links to file location and GIS image. A BUIDINGS table, because we have multiple buildings at some sites, with similar info. A PROJECTS table for work order or tasks that can involve numerous sites and building at the same time. A DEPARTMENT table, for departments effected/involved in the project. We need to be able to search by keyword or fields from all the tables to retrieve all records that involved and related to each other, all that in a form design. I have created one form with SITE fields and made subforms for other tables into this form to view or edit them. Had to use subforms in order to get it to work, I was going to use tabs but all records would not show when I entered all table data into the form. I would guess I need to create queries for a keyword text box with list box requery, and queries for text boxes for field text boxes, but not sure how to write the functions or codes needed to make them work. Any help or advice would be appreciated.
2 MB Views: 11