Creating a user submitted query
I have been looking for some time for a relational database solution for a simple membership app and I'm hoping this might work. I used to be a database admin years ago but was not a programmer. I did a lot of SQL and some simple scripting but don't have a lot of coding experience.
I would like to create a relational database with I think 3 simple tables, a member table, a registration table, and a merits table. The master table would be the member table and contain all pertinent data about members, name, address, certifications, etc. The registration table would generate a row when a member pays registration or renews. The merits table adds rows when members earn merits or points through service to the organization. After a certain number of merits are earned there are degrees given. This list is currently being maintained manually and not very well. I would like to put this in a database so that members can query how many merits they have earned, dates, and types of merits and well as when does their membership expire.
Can I do that with this app? I have created the tables already and am impressed with the functionality of the forms. I have seen reports and how to list the entire table or filtered table but how can I build a query where the user would enter their own name or the system would recognize their login and allow them to query their information only?
I am on the second day of the trial and if this works my organization and many others across the country could use this to manage their degree programs.
Thanks for whatever help you can give.