HELP!!!

[Kennya1]

I am trying to relate two database in Vb6 and get the following error

"You can't add or change a record because a related record is required in table "

Also (this is a real newbie question) once related and your at a record in the first database how do you get the information on the foreign database

Any web site tutorials will help

 

[FoxProProgrammer]

You are probably getting this error because the "Enforce Referential Integrity" box is check in the relationship, and you added or changed a record that violated the referential integrity of the database.

If you have the parent table open and the relationship is set properly, Access places a + sign to the far left of each record. If you click the + sign, it will show you the data for the related child table.

dz

 

[Kennya1]

THanks for the advice. I get this error when trying to set the relationship in Visual Basic 6. WITH THE FOLOWING CODE


Set db = OpenDatabase("All Data.mdb&quot

Set rel = db.CreateRelation("Test&quot
With rel
.Table = "ChartNew"
.ForeignTable = "D2002"
End With

rel.Fields.Append rel.CreateField("Name&quot
rel.Fields("Name&quot.ForeignName = "Name"

db.Relations.Append rel