Just wondering if this is doable in Base…I know it’s doable in Access.
I am using the Mac version by the way.
I have a Calc file with three tabs.
I import it into Base by connecting to my Calc file in the wizard. All three tables appear in Base.
When I try to run a join, either via SQL or the wizard, I get an error saying that it can’t be done because more than one table is selected (that’s the point :-D).
When I try to create a relationship, I get an error that says the database does not support relations.
I have to use a Mac because it’s what everyone here uses…I would be happier in Access, but also happy if I could do it in Base too TIA!