Recent content by tr91
-
T
Table relationships and structure.
Thanks very much for your effort. I was away for a while, but I created structure like you suggested, but struggled to create data input form, just to test how it works. I tried to use form wizard, but no luck.. I attached empty database with the tables and relationships, based on your example... -
T
Table relationships and structure.
Ok, I took your advice, and drew the tables on paper, then step by step entered the data as I need. Finally I saw the bigger picture how the data will be related using the keys. But.. everything would be nice and easy if one column only with values positive or negative would ne enough. To be... -
T
Table relationships and structure.
Thank you, you are being very helpful. Your guesses are very good, its pretty much how it should work and it makes sense to me. Just a few thing though.. As there are various tests and each test have different parameters, there should be result table for every test, and all these tables should... -
T
Table relationships and structure.
Ok, thanks. I know its probably too much to ask, but maybe you could provide me with simple database with 3 tables (each 2 or 3 fields) ProductTBL, TestPerformedTBL and TestResultTBL properly related and a simple form to input data in all 3 tables. I tried it myself, but always got confused on... -
T
Table relationships and structure.
jdraw, Again, thank you for your time. Ok, Ill be a little more specific. We are plastic pipe manufacture company. We produce plastic pipes from many materials for many purposes, like cable protection, drainage, water, gas and so on. Various tests are performed to every product, like impact... -
T
Table relationships and structure.
RogerCooper, jdraw, Much appreciation for your help. I went trough all the information you gave me, and I have an idea now how to structure the tables and treir relationships. But Im still confused how to design a SINGLE FORM for all these tables. With all the data in one table it was easy... -
T
Table relationships and structure.
Hello, First of all, sorry if Im not clear enough, english isnt my native. Im quite a beginner in MS Access and databases in general, so I need some help in designing tables and their relationships. Im trying to create database for product testing results, where each product can have many...