I am trying to figure out create a new table from two other tables. It is a tax document and one has a pin field that is unique and the other the pin field is not unique. So in the table the that doesn't have a unique pin field, the pins occur multiple times for all the different tax enitites people pay to. I need figure out how to make one table that combines these too. I have tried using the relationshop function but i am not sure if this is what i need to do and i am not that familiar with access. If there is anyone that can help me please let me know. or if you need any more information.


Thanks
Justin
Mclean county regional planning commission

First, I would be cautious about posting others' emails in a public forums.

Second, the email was barely readable. I'm not 100% sure what you are trying to accomplish here. It's very helpful if you can put into more concise wording about the problem and what you want to do about it.

I can't really give you any suggestions because I don't understand what exactly is the problem and don't want to send you down wrong track. When you've either rephrased the problem or uploaded your sample database for us review, we may be able to help you along.

There is no reason to create a third table. In a relational database, you use queries to join tables. Access allows you to use queries pretty much any place you would use a table. So, use the query as the RecordSource for your report.