Noob Help

[mryanp]

I am brand new to Access and slowly figuring things out. I am trying to create a database to manage my workload. I currently have created two tables. One is for my customers, and the other is for my orders. I can't for the life of me figure out how to build a relationship between the two. I have lots of customers and they all have one or more orders. I've also created a form. What I would like to do is have something like this http://office.microsoft.com/en-us/te...001018548.aspx . I downloaded this template, and tried to modify it, but I think I've messed things up trying to edit it. Most of the information in this I don't need, but I would like to see the orders for the given customer as it is in this template. I realize this is a huge question, and may likely not be answered, but I appreciate all the help I can get.

[June7]

We can't help if we don't know what's wrong. Why doesn't the template db provide the result you want - error message, wrong results, nothing happens? What did you change? If you want to build your own from scratch, did you study the template data structure and figure out how customers and orders are related?

Orders table needs a field to save the primary key from Customers table as a foreign key.

[mryanp]

I've been doing some more work on the template listed above, and these are my issues/what I've done.
-I have deleted anything pertaining to pricing or shipping, as I don't need this information. I removed the relationships and deleted the tables. I haven't done the forms yet, but plan on doing so.
-After I made these changes, I click on the switchboard form to open it and receive this error :"Run-time error: '2465' can't find the field 'Option3'
Aside from this issue I think it will work for what I need it for.

[June7]

I don't use macros nor Switchboards (they use macros). I build my own 'main menu' form and use VBA code.

Sounds like something on the Switchboard needs to be modified. Something on the Switchboard is trying to load something from something you deleted.

[mryanp]

If it helps, this is the line of code that is highlighted when I debug.

Me("Option" & intOption).Visible = False

[June7]

Not enough info. I presume that line is in a looping structure and when the intOption increment reaches 3 and tries to execute, it isn't finding 'Option3'.

Suggest you revert to the unaltered template and get a better understanding of the structure before modifying.