Hi All,
Brand new here. Used to be an Access developer back in the day and not done any DB stuff for a good few years. I am in the process of learning Alpha 5 (only been doing it a few days) and I have been playing about. I have MySQL all setup and have Alpha 5 talking to it and have tables all setup etc.
One thing I am struggling to get my head around is how table relationships and joins work in this. In Access obviously I made the tables within Access and built all the relationships there. Then when I used tables/queries in forms etc they would all be linked and work together nicely as it was all in the same 'place'.
I am trying to make a web application and can�t fathom where and how my table relationships work. I have created the joins within MySQL and all the tables look related correctly. However (and I have not played about that much with this bit) when I make components and queries in Alpha 5 do I have to create all the relationships/joins again or does it know about the joins I have already made in MySQL. Reading it back it seems a silly question but I am not used to building databases where the front and backend are in different environments. Can anyone explain how that works so I can get my head around it?
Thanks for any help at all.
Matt
Brand new here. Used to be an Access developer back in the day and not done any DB stuff for a good few years. I am in the process of learning Alpha 5 (only been doing it a few days) and I have been playing about. I have MySQL all setup and have Alpha 5 talking to it and have tables all setup etc.
One thing I am struggling to get my head around is how table relationships and joins work in this. In Access obviously I made the tables within Access and built all the relationships there. Then when I used tables/queries in forms etc they would all be linked and work together nicely as it was all in the same 'place'.
I am trying to make a web application and can�t fathom where and how my table relationships work. I have created the joins within MySQL and all the tables look related correctly. However (and I have not played about that much with this bit) when I make components and queries in Alpha 5 do I have to create all the relationships/joins again or does it know about the joins I have already made in MySQL. Reading it back it seems a silly question but I am not used to building databases where the front and backend are in different environments. Can anyone explain how that works so I can get my head around it?
Thanks for any help at all.
Matt
Comment