Hi
I have just purchased the access basic series and worked my way through them. I have now purchased expert 1-3 however I seem to have confused myself somewhat! i am trying to build a database that will have 3 different forms. My question is do I need to make a separate table for each form and if so is there a lesson where I can create relationships between forms.
Many thanks

---

Reply from Richard Rost:

If each of your forms deals with a different kind of data, then yes, you need three tables and three forms. Relationships are covered in Access Expert Level 1.