the main objective is I can't retrieve the data from the table (master recrod) when I key in data related to that table that link each other.
for example : table A, table B (master record) - related each other with no primary key assigned.
when I enter the data from field name table A, then the other record related with that number in table B will appear. So any suggestion is fully appreciated.
In my own opinion it is best to set a PrimaryKey in both tables and then set the ForeignKey in one table to set your relationships. That really should be the basis of how you set up your tables in a RelationalDatabase system. I may be wrong and you can do it a different way, but I think you will be making more work of a simple task. If your relationships are setup correctly in the beginning, then relating tables is really easy work. Just my thoughts on your situation.
have a nice day,
and again Welcome to the Forum.
In my case, I tried assigned them with primary key and foreign key coz they are the basis of relational DB. But, the result is still can't to get the result. the problem is regarding referencial integrity. But after I try to make sure all related field name in the same index, its still told my thats problem. I think maybe the record database dont match with the related. So for your suggestion maybe very helpful..and I hope so...coz my taks to complete it is very urgent now
Can I ask something? Could I attacth my sample of table for more easier understanding?
That would help a great deal in getting someone to better help you. Remember to remove all pertinent data and replace with dummy data. Then let us know just how it SHOULD work. Maybe we can then help you out.
Make a COPY of your database and then Zip it with WinZip or something. Then Attach here in the forum and that's it.