MySQL Forums
Forum List  »  Newbie

Using Fields in Parent Tables
Posted by: Mel Davies
Date: May 18, 2022 10:52AM

Hello,
I'm new to MySQL and also to this forum but I have managed to create a database with a parent and child table with a foreign key field in the child table.

The child table can invoke an index value from the parent table, and I can see that any id I enter that lies outside the id range of the parent table is rejected.

That's all fine but an id is just a number and is not meaningful to a human.

My question is this: How do I get a Varchar field from the parent into the child?
So far I haven't found any help on this.

TIA

Options: ReplyQuote


Subject
Written By
Posted
Using Fields in Parent Tables
May 18, 2022 10:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.