Hi everyone, I've been using OpenOffice for a few years now. But recently took on a project to help build a database for a mobile home park... Basically, they are storing tenant information, emergency contacts, etc.
Basically, I'm trying to achieve two results at the moment... 1. To create dynamic reports based off of different search queries. It's hard for me to put into words what I'm attempting to achieve. But, let's say the owner is wanting to find every tenant with the last name of "Jones"... I'd like to be able to be able to implement a search feature that would pop up a text box. He types the name, "Jones" in the box. And then a report is generated with the list of everybody with the same last name... I'm sure this would be query based, however, I'm not sure how to implement the search, direct it to the particular field, and then generate the report. 2. I'm also trying to create a "Switchboard" as I've seen it called in Access... Where when the database is opened, he can simply click on the function he's attempting to perform... Let's say, Tenant Maintenance button would take him to the form where he can add or edit tenant information... If anyone has any suggestions for this techie trying to wear a development hat (which is not working so well), I would greatly appreciate ANY advice. Thanks,
