Forum Discussion
Relations 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...
In 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