655 Posted Topics
 | Okay, here's the simple explanation: 1. If you think about an order, it has header information at the top, then individual order lines. You can order any item on any line. You can order the same item on different lines. The line doesn't care, all it cares about is what …  |
| | My $.02 worth: Based on your description of the process the user goes through, the diagram you showed is pretty tight. Meaning, it is the minimum data structure that would support your description. It's unfortunate that it seems clunky, but there you go. If you remove any of the relationships … |
| | Let's see if I can help. I may be making some wrong assumptions based on what you posted, but I'll do what I can. 1. It sounds like you should have an entity "StaffMember", uniquely identified by "StaffId". This would contain the list of all Module Leaders and all Tutors. … |
| | Not sure if this will help, but have you tried creating a separate MDB file on the local machine and linking to the tables in the network MDB? Then you can write your VB to go after the local MDB and let the local jet engine deal with the latency. … |
| | Hello members! I was browsing through looking for something completely unrelated and I found this site. It took me only a few minutes to realize that this was something I could use and (hopefully) contribute to!  |
The End.