Ok I'm a newbie when it comes to MySQL but I have done work in Oracle before and written allot of SQL code in my access DBs. I'm working on converting the tables from one of my Access DBs over to MySQL. I've got the tables all built they are all TYPE=InnoDB so that i can use foreign keys but my issue is this.
In access I would do lookups to queries that would restrict the data from the master table so that the child would only see what I wanted it to. I was hoping to use a view for the FK to restrict my data in MySQL just as I had done in Access with queries. well unfortunately this seems like this will be impossible, correct me if I'm wrong.
I'm positive there has to be a way to do this I just have not been able to figure it out , any help would be greatly appreciated.
T.I.A.
In access I would do lookups to queries that would restrict the data from the master table so that the child would only see what I wanted it to. I was hoping to use a view for the FK to restrict my data in MySQL just as I had done in Access with queries. well unfortunately this seems like this will be impossible, correct me if I'm wrong.
I'm positive there has to be a way to do this I just have not been able to figure it out , any help would be greatly appreciated.
T.I.A.
Comment