HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 10:10
- Joined
- Apr 1, 2019
- Messages
- 731
Friends, I'm in the process of writing a stock control database & intend to adapt the "Allen Browne" method of calculating stock on hand. It's to do with a primary asset and allocated spareparts to that asset. When I 'scoped' out the project I designed a many:many relationship with contacts (that is suppliers) only to realise later that 'contacts' maybe suppliers and/or customers. So I'm in the process of adapting my relationships to suit. I've had a prolonged brain fade & am now stuck. If you open 'frmPart' and select the 'suppliers' tab as an example, (but repeated similarly in several other hyperlinks), then select the hyperlink, the double click event used to open up the correct form. But since I added the 'link' table 'tblSupplier_tblContact' & changed the relationships, then the hyperlink does not open the correct form. I can see why, as in previous versions the link was between 'tblPurchaseOrders!SupplierID' & 'tblContact!ContactID' now it's to 'tblSupplier_tblContact' field, which is clearly not the same as 'ContactID'. If I've made any sense.
My intention is to have a 'contacts' list in which a contact can be a customer or supplier or both. Not quite there yet..................
If anyone has the time, I'd really appreciate a critical review of my database structure. I often have trouble in the design/normalising/sensibilising(?) process. All help is appreciated. As I say, brain fade has set in!
My intention is to have a 'contacts' list in which a contact can be a customer or supplier or both. Not quite there yet..................
If anyone has the time, I'd really appreciate a critical review of my database structure. I often have trouble in the design/normalising/sensibilising(?) process. All help is appreciated. As I say, brain fade has set in!