Recent content by ixusss

Thanks a lot. Took me a lot of time and I couldn't figure it out. Gee.. seems pretty simple now with the method you suggested. And thanks for the advise.

Sorry, I should have stated that in the query I also have First Name | Last Name Is there a way that I can put in a text box in the Form Header and edit the control source to achieve the result? Thanks

Hi all, hope you have help me with a project i am working on as I just started to learn Access. I have a table, Client, with Client ID | First Name | Last Name And I have a query, Client Extended, with Client ID | Client Name How can I show the Client Name with the matching Client ID in the...

Thank you for your comment. There will be other fields in the tables. For example, in the property table, there are property value, location, and return rate. In the Tenant table, there are income, job information... To answer your question, the reason for information being stored again...

Thank you Neileg. The reason why I wanted the Contract table to be able to check other fields in the table because i wanted it to prevent mistakes and confusions such as wrong tenant ID for the Contract ID or wrong Property ID for the Tenant ID. Does it mean I just have to manually check the...

Thanks for your reply. 1. Clients own the property. 2. Properties can only have one tenant. 3. Tenants can only locate in one unique property. In addition, Clients can own more than one property. Thanks.

I am new to Access, and I need some help for this project I am working on. Please let me know if my question doesn't make sense. I have created four tables: Clients, Tenants, Property, Contract Clients Client ID | Client Name | Tenants Tenants ID | Property ID | First Name | Last Name...