Hi,

First of all, I hope this is related with Firebird.

I have problems with declaration of Master/Detail rel. between two tables.
I want to join them by using a IBDataset, like;

SELECT
A.NAME,
A.NO,
B.ENTERDATE,
B.COUNT
FROM NAMESTABLE A
INNER JOIN DATESTABLE B
ON (A.NAME = B.NAME)

I put 2 edit field for Name & Number and 1 grid for B Table(Enterdate,Count
columns)
and one data navigator.

When I try to post a new record it says "B.count must have a value (cannot
null)"
But I want to post only values of NAMESTABLE.

I think I need to have two seperate IBDataset for performing this.
I do not want to use IBTable ( everybody is saying this :)), with IBTable it
is easy I can use Mastersource and
MasterField property to set it.
I want to learn the controlling this master/detail by using SQL commands.

Any help will be appreciated.



[Non-text portions of this message have been removed]