Database structure help

[DanHolland]

Hi im attempting to build a database for bin weights by customer i currently have the database model as below;

* Customers
* Customer Sites
* Bins on Site

on the 'bins on site' table i have for example

A/c Waste Type Quantity
Customer 1 General Waste 2

i would like to be able to assign a unique ref no. to each of the bins for each customer (customer 1 would have a ref no for 2 bins.)

does anyone know of how i would go about doing this? :banghead:

 

[plog]

Put an autonumber field in the [Bins on Site] table (you should also rename it so that no spaces appear in the name--do that for all tables and fields actually).