I would always recommend having a primary key; if you don't need it now, perhaps you will need it later; if nothing else, it will help you refer to records while debugging.

MS Access does support...

Are you familiar with VBA? If so, the code you need should be something along the lines of this:


Private Sub Combo182_Change()
Combo183.rowsource = "SELECT Models.[Model Name] FROM Models...

As far as your error.. can you show the original code, which I assumed worked, and the modified code so that we can see the changes you made.

On the line you referenced, you have the following:
...

You need a Supply ID primary key in the Supply table with event no and wedding no as foreign keys. The way you have it set up currently, each event/wedding can have only one supply (I'm assuming the...

From what you described, it sounds like the VLOOKUP function will work.

You give VLOOKUP a value, a range and a return column. The function will then look for the value in the range and then...

What is the difference between the lecture entity and the session entity; isn't a lecture just a type of session? Same with practical session and session.

I see you removed the relationship...

This is how I would approach the issue. I would have one table to track the bills, one table to track the people and one table to track the transactions:

Bills (ID, amount, date billed, date due,...

Well, if you don't want to use a class but instead only use an array, I recommend using a multidimensional array. A multidimensional array will allow you to store the lengths and widths of each room...

This is my recommendation:

Create one 'user' table that stores, at a minimum, UserId, but could also store name, DOB, etc.

Create one 'Attributes' table that stores all the different...

Here are the steps to making one cell display the information in another cell. When the source cell is changed, the cell that refers to it will change as well:

1) Click on the cell that will...