Guy / good advice here on how to build what you need. Without going into more detail than you want to hear – I have ‘chased’ the home budget holy grail for 10-15 years. There is still no web based or software application that meets my needs – (Not ...
each person can have many activities
each activity can have many persons
therefore, you have a many-to-many relationship – which needs an intermediate table. lookup many-to-many.
I am in a similar (frustrating) situation – coming from many years of Access autonumbering and column choices in dropdowns. The formula above looks more like macro code to me. – In other words, how do I use this formula/where do I put it? I have an ...