Forum Discussion
I_NeedMorePower
Helper III
Helper IIIRelations help
Hello Power community! I want to create a 1 to * relation between two tables. for example the tables are: Table 1: Items (YearID, BranchID, ItemID) Table 2: Trasactions (YearID, BranchID, ItemI...
AnthonyTilley
Solution Sage
Solution SageIn my opinon i would have suggsted the concat colunms approach you mentioned. and join the two colunms. but this is only really suitable if you are using only these two tables and they are small data sets
If you will later want to beable to filter or calculate based on the year table or Branch table then you will need these tables anyway so would be best to go down the prefered route and bring these tables in and use them as a bridging table between your two tables above.
I always try to follow a rule that the least amount of calculated colunms is probabaly the best approuch