Recent content by getssmart

What happens if you need to link both a supplier and a customer on the same form? This is the exact same situation I have.

No it would be in almost every case, I had to simplfy the scenario and make it hyperthetical. But your response is appreciated, thanks.

Hi In a hyperthetical situation if Fred and Jim are both a customer and a supplier. How would I structure the relationships/joints so that I only keep 1 table whether they be suppliers or customers, but on a form I want to say I have bought items off Fred and sold them to Jim. When using the...

Oh how much I have to learn! Thanks for your help, I did not really understand your answer but it made me look in the right place and when I changed some options in the join type, it fixed it. So together we have muddled through this problem, well see whats round the corner. Thanks again. Mike

Hi Yes the record source is a qry, but not sure how to make the join, as you term it. I cheated by quickly making a new form from the wizard using fields form both tables then copied the record source from the new form into my existing form this seemed to work except for the problem posted...

Hi Newbie to your forum and a bit of a novice in access too. I am building a db and a form that was previously able to be filled. When I altered the form and added some fields from a different table now just dings when I try to type in any of the old fields, but I can enter new data into the...