Recent content by Julie van Heerden

Thanks I will let you know the outcome , I must say I love anything like this and can sit for hours my daughter on the other hand hates anything like this. When I first started I was overwhelmed but if I can get those primary keys set on that last table I will be a lot futher then will need to...

Thankyou I will certainly look at that , to be very honest the whole assignment gives very poor instructions , its really ridiculous as time constraints are an issue , also both my daughter and I have not worked with Access and the training provided is very basic. I am sure I will come right in...

The data was given and exported from excel , I did split the two tables and delete the duplicate records in Warehouse and managed to set the Primary key in that table , But they ask for two primary keys in the Storage Unit table. The two fields Warehouse ID and Storage Unit ID together create a...

The Assignment given has very poor instructions I have attached a spreadsheet and a PDF file on how the tables and the Links must be . In the excel spreadsheet Warehouse is One table but if you look at the database they want the Warehouse table split , problem is they want the WarhouseID to be a...

Hi I am attaching the excel file and a PDF file as to the project please look at the Warehouse table in Excel and the tables in the PDF file how they want the table split the highlighted fields are the Primary Key Thanks

Hi there I am work at present and only have the Access at home so cannot try until this evening , but I know that I did go into design window and highlighted both fields and set as primary keys when I want to save the table it gives me an error , will have another go at it this evening , as...

Thank you but the tables have duplicate data so it will not allow me to Warehouse Table and Storage Unit Tables both have duplicates WarehouseID must be set as Primary Key W1 W1 W1 W2 W2 W2 Storage Table WarehouseID StorageID (must both be set as primary keys) W1 RT001 W1 RT002 W2 RT001...

Hi Please help , I am very new to Access 2010 and I am helping my daughter with her assigment , There is a Table for Warehousestorage Units which has several fields. On the plan they split this table in to two One called Warehouse the other called StorageUnits , in the Warhouse table they...