Search results

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)

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