cwazyruss
Last Activity: Jul 16 '19, 03:05 AM
Joined: Jun 27 '19
Location:
-
Thanks, Twinny and yes I'm learning them both. I need to use MySQL because I want it to be web-based, so people can enter and retrieve data via their own devices. The company is included so I could alow separate businesses to use it, but restrict data based on a company login. I am using access to test my tables as its easier to build forms and querys there for me at this stage. I am then creating a similar set up in MySQL. I have cleaned up some... -
Relationships for cascading tables
Hi
I am new to database design. I am building a database to handle the paperwork for boat companies maintenance. I have made a series of tables using foreign keys to interlock the tables. I think ive done it wrong as i have relationships from the first table to all subsequent tables. See pic. Is it enough to just link one table to the next without all these extra relationships?
Regards
Russ... -
Thanks. I think linking to tbl1 and tbl2 will solve alot of my problems. I am new and the curve is steep. I will keep at it though.Leave a comment:
-
Using a form/sub form to enter data
I have created a data base with 3 tables. The first table has only 2 records and each record is linked to many in table 2.
I have used a form sub form to eneter table 2 data without problems. I just select the name of the record in table 1, and enter everything else in table two. In table two I have used a lookup to table one for the name in table one. This worked and the datasheet in table 2 showed many instances where each of the...
No activity results to display
Leave a comment: