Some time ago Ken Sheridan taught me to combine my business’s 7 entities(Creditors, Employees, Agents, Customers, Cash Suppliers, Banks, other). I call that table t01CombinedEntity. It works well for all purposes. To end up with effective financials it all have to go through Union query, still no issue.
1. I created a table t01Image with foreign key CmbEnt_ID, and field Logo01.
2. The foreign key joins nicely with CmbEntID in t01CombinedEntity and query q01CombinedEntity and records meet with images, no problem.
3. Query q02InvPurchase is joined with q01CombinedEntity and works well after I joined queries q01CombinedEntity and q01Image. The Image field Logo01 is part of q01CombinedEntity but not in q02InvPurchase yet.
4. My problem is when I click on Logo01 to make it one of the fields in q02InvPurchase(to be able to place the image on Invoice); q02InvPurchase does not work correctly any more. I changed the join properties and the query shows all the records but is not updatable.
Im missing something. Should I start drinking alcohol for the first time in my life, or am I just old?