Recent content by samjl6

Not to worry all! I've managed to fix the problem! After having an old friend who works with databases look at it, he suggested changing the source type of the subform to the table itself (despite someone telling me to create it as a subform on another forum question that I'd posted) and then I...

Okay, I've just tried, but nope, still coming up with like 5 of the same records for different people...

Could you talk me through how I would do that?

See attached for the two tables I am trying to link and the relationships. Is this correct? What else do I need to do?

So I've set up a form for each of my subscribers, with a subform containing the orders they've made. However, as you might be able to see from the forms I've attached, only 2/6 forms are showing the correct orders for the correct people. The remaining 4 forms are just showing a list of 4 other...

Thank you. Now that I've made my forms, how do I view each individual's form? Like if I wanted to scroll through and find an individual's details (now also with the orders table attached to it), how would I do it? *Sorry if I sound stupid! I'm really really new to this!

Oh gosh, I am VERY new to using Access, so you've just confused me a rather large amount there! Yes, I have a table for purchase orders and a table for subscribers. How do I go about linking them? (Preferably a nice basic, step by step instruction if it's not too much trouble to ask?)

I'm quite new to Access, but have started using it to monitor all of my mailing list subscribers and purchase orders. My question is; is there a way to create a profile on each person on my database, to show their contact details and whether they've made a purchase from me before, or must I...