Recent content by londonworker

I have to tbls which have indeterminate relationships and I'm told that ther is no unique index found why is this? i am using emplyID on both tblCommission and tblSales both are number type. I might not need the commission table as I'm using this is calculate commission as said im my previous post

sales target table = allows collection of employee sales figures in order to work out commission. Fields included are target, date, sales achived and commission allocation %. This info will be entered via a query below. i need to create a query that allows entry of employees sales targets...

I need to set up an update query for stock levels. How do I go about doing this? (this should be up-dated directly from the database window)

thanks again i was actually talking about tblDelivery not the other one

thank you, deliveryID is autonumber but contains duplicats so can't be PK. The ProductID field is the only colume without duplicate data. Should these two fields be changed round?

I have a table containing the fields: DeliveriesID // SupplierID // Date // ProductID // QTY // costprice // totalprice I need to make this table 1NF. I know I should make related tables but I'm not sure what fields go with which. I have attached a copy of the database