Search results

Thanks Guys, Much appreciated Craig :D

Thanks IgorB How do i compact the database? Regards Craig :D

Hi Guys, I have a field set as an Auto Number. I entered some text in the field to the right of it...And it generated an Auto Number. ... . Number 1 I then deleted this record, And went to type in my real data, Only to find that the Auto Number started from 2... How do i reset the Auto...

Ok Rob, When i drag my primary key field in the relationship view to the field i want to link it to (In another table) i just get a line linking them. I dont get a number "1" or one of those signs.... Why is this? Regards Craig :D

And, How do i delete a Relationship once i have created one? Regards Craig :D [EDIT] I have done it...

Also Rob, Would it be possible for you to explain how this was done? As i need to explain what happens as i go along. Regards Craig :D

Hi Rob, Thank you very much for this :) Im going to have to work on it now... I sent you a PM....Can you check it please? Regards Craig :D

Thanks for that Rob, It helped me a little more... However, Instead of the relationship displaying the Staff ID ... Would it be possible to display the Staffs Name, The Time and Date of the Massage, And whether or not the Member has paid? I would also want this to be set up into a form, So i...

Hi Rob, Im at school at the moment and i dont have the file here. However, I will try to explain.. I have 3 tables now Tbl_Members Tbl_Staff - Contains a primary key field with auto number to give the Staff an ID Tbl_Massage - Contains a field called Staff ID which i would like to link...

Hi Rob, Thanks for that...It helped him alot. But...I can't get my head around my project.. The staff Id etc for the massage table. Can you help with it? Regards Craig :D

Thanks alot guys :) Much appreciated... And Thank You very much Rob for the example... It helped him alot :) Regards Craig :D

Hi Guys, Please excuse me from asking this question but, I am completing a project for school and school have access 2000. I have access Xp on my computer at home and when i save files here, I can not open them there. How can i get around this? Regards Craig :D

Also, In MY project, I have two tables... I have a "Staff" table and a "Massage" table. How would i be able to link the two together. Where the Massuers name from the "Staff" table would link with the Massuers name in the "Massage" table. Then i will be able to view which Massuer is giving...

Hi Rob, He would like his project to have more than one copy of the same video. He would also want to allow more than one video to be rented at the same time by a member. Regards Craig :D

Hi Guys, Im in year 10 at high school and our group is completing our 1st piece of coursework. It is a design project, And my friend would like to set up a relationship. He has 2 tables and i would like to link Video Number (Table 1) With Member Number (Table 2) So he can view what Video...