Recent content by salim

I tried to upload the file but it says invalide name...? it did work the stuff,thanks for your ehlp, I might need some more as i will have to implement the system for the small company, that's if nonme of you mind helping, it's form and inserting data, like when we receive order then we have to...

I tried to upload the my db file but it says invalid file...anyway i got it sorted for now, I hope I wont get stuck somewhere, thanks for your help, much appreciated

yep, it's been a long time sisnce I haven't done this, anyway talking about the end 1:m, if the PK is autonumber, the FK should too, but how could I set the relationship, it's not allowing me

you said I will drag the PK to the FK, my question is: is the FK in the other corresponding table where I drag to would be set as normal as an attribute or do I have to assign it like I assign any PK, i.e to have the key icon, in other words should the FK stay normal, or would I have to assign...

Thanks Rabbie for the help, but all I am trying to say is that I cannot do it, anyway I am sure there is something mixed up all along, anyway a quick question, do we set the FK as PK? say vehicle_type is PK in the table Vehicle_Type_tbl and FK in Vehicle_tbl, when I assign it as such do I assign...

how about if I don't use autonumber? again with this rule I cannot use it because a Vehicle Registration Number is unique and cannot change, in the company we have a set of Reg and cannot nver be auto. the problem still is there, I cannot solve it, where is it, some said that I need to go and...

i don't think I need artificial or surrogate key as the one I have is ok, but again the question o the problem remains that while I have the vehicle_type PK inb the other table it's automatically a FK which will becomea PK in the design, is that correct? remind me if I am not plz, how do you...

Hi again, I think my problem is so complex, I have been working on it and I came up with some solutions, now my question is as follow: I try to establish a 1:m between two entities or table ( vehicle_tbl and Booking_tbl) but I cannot, i get the error message of not finding the index key, anyway...

Hi, I want to design a db for a small car hire, i am not sure about the entities, but this is how the system is: a customer (s) call to book a vehicle (s) on a particular day (s) of the week or month to pick up at certain time the rate for the vehicle could be different from small to medium...