Primary key and entering data

[Sa7ar]

ok great

 

[Sa7ar]

khodr
could you please attach the converted database ?

 

[khodr]

Sa7ar,
I am stuck, I am trying to convert the database to an earlier version, but it won't, actually I used some controls and features which only works with Access 2010, you got to try this

1. Open Microsoft Access 2007.
2. Create a new Blank DataBase .
3. Click OK.
4. Goto External Data menu and the Click on the Access Button.
5. choose Import table, queries, forms etc....
6. Import all the objects from the previous database to the new one.
7. Save the new database.
8. Close access and try to open the new saved database again.

I hope you can run it because it will be really what you are looking for.
else, the last option, you have to install Access 2010 and run it and for sure no problems after that things will go ok, else if you have a firend who has Access 2010 you can open the database on her/his computer and check how it is done and try and do it again on Access 2007

 

[Sa7ar]

well .. importing didn't work
so I will try to get access 2010
and I'm sure I will get to learn alot from what you added to this database
thank you so much for your help

 

[khodr]

You are most welcome sa7ar feel free to post any question and this forum is full of experts and answers
Happy New Year 2013

 

[Sa7ar]

HaPPy NeW Year

 

[RainLover]

and the primary key for the three tables is the Registration Number

If this is still the case then what you have is Three tables with a one to one relationship.

This is the same as using One table.

You can't continue with this design. Please read up on Normalisation and database design.

Also have a look at the Northwind Database from Microsoft. It may help you to understand.

 

[Sa7ar]

now I'm using one table for all products but i can't use the registration number as the primary key because some products still didn't get their registration number as they are still under-registration
thanks RainLover

 

[RainLover]

now I'm using one table for all products but i can't use the registration number as the primary key because some products still didn't get their registration number as they are still under-registration
thanks RainLover

I don't think you read my post correctly or I didn't write it properly.

What I am saying is that every table must have a different primary key and with every record the PK must be unique.

You CANNOT use registration number as the primary key on more than one table.

 

[Sa7ar]

What I am saying is that every table must have a different primary key and with every record the PK must be unique.

You CANNOT use registration number as the primary key on more than one table.

I'm not using the registration number as the primary key at all
what I meant was that the registration number is unique for each product but I can't use it and I didn't have any other unique field that can be used as the primary key so now I just use auto number field as the primary key for this one table

 

[RainLover]

I'm not using the registration number as the primary key at all

the primary key for the three tables is the Registration Number

You are now saying the opposite to what you said in your first post.

If you are using Autonumber as Primary Key in every table then that is the best way to go.

 

[Sa7ar]

well that's because the first post was three weeks ago and alot have changed since then, and now I have one table instead of three and the primary key is auto number

 

[RainLover]

I understand.

Good luck with the project.

 

[Sa7ar]

Thanks
and I will read more about database design, thanks for the advice