Thanks Bob. Then next problem, I don't know how to zip a file! Any tips? Otherwise I could email it to you.
Thanks Bob. Then next problem, I don't know how to zip a file! Any tips? Otherwise I could email it to you.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Thanks Bob. I'm very much hoping this works!
I'll wait for the database before any detailed comments. But here are a few general things:
-did you work through the tutorial I suggested in post #8
-the list of "things" I gleaned from your post were things I saw as potential tables
-you really can't comment on the design of tables and relationships until you know the business rules
-business rules determine relationships
Thanks Orange. I did read through it, but it wouldn't hurt to have a more thorough read. I'll check again now.
Generally I feel confident with what I want from the data, but maybe I'm missing the point.
By the way, I uploaded my file 3 posts back. Just in case it got hidden amongst the messages.
Hi Neil
I've created some forms, similar to those that i used in the attached db in post #2
Hopefully, this will get you started.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Many thanks Bob, I'll take a look once I'm back in my computer.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Thanks very much Bob. I just had a look, and it works really well. What's the easiest way now for me to incorporate it to the original database? Should I try to recreate your forms, or should I replace the tables with mine? Thanks again.
You should be able to just open your original db and import the three forms that i created in the last one posted
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Thanks, that sounds really straightforward. I'll give that a go.
I managed to export the forms, and its working well, thanks! I took on board for suggestion about about the referential integrity.
I'm sure I'll have more questions soon!
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick