Recent content by mdlister

ok so i was a little confussed and resorted to the classic pen and paper to draw me out the diagram of what the tables would look like and put some data in to see what would happen and i think i have it tblScript ScriptID(PK) VersionID(FK tblVersion.VersionID) Date Created Description...

Thanks Doc Man, i understand most of what you are saying, i am trying to get the database structure as you suggested but am a little confussed with some of the things you suggested? i have modified tblLines and created a tblVersions and left tblscript as it is. tblLines LineID (PK not...

Morning, Novice when it comes to tables and designing them, and am looking at a way to create a database that will store all the scripts that i create to help me do things as well as maybe keep version control so that if i modify it i can see the modifications and role back if things go bad, i...

Ian ur my hero! works a treat! thanx very much! :D

Trying to create a query that will look up a barcode and subtract 1 from the currnet stock levels, i have the exact same sql statement for the adding of stock part from the -1 to a +1 the relised i may need a gap between the "-" and the 1 but it still comes up with the message. Anyone got an...

UPDATE Table1 SET Table1.quantity = [table1]![quantity]+1 WHERE (((Table1.barcode)=[enter barcode])); is this query string rite to add a number to the stock of a certian barcode and what kind of validation can be done to check if the barcode exists?

Hi there, i have a database i am setting up with 4 tables and am trying to think of the best way to input new data into it. All the tables are linked and its all based on printers. When a new printer is brought if it exists in the database then thats cool it just needs a Printer number assigned...

thanx hey, thanx for the advice tho its a one to many relationship between the make and model as theres only one make ie cannon and many model numbers for that specific make.

Can anyone look at this pdf and let me know if my relations are correct, i know i haven't marked on if its one to many etc but i just need to know if it'll work?