Re: Master-detail don't work??? (MasterField type Date/Time)

"macaileacs" <available@xxxxxxxxxxxx> wrote in message
news:456b6c4c$1@xxxxxxxxxxxxxxxxxxxxxxxxx

The field tht links the tables (primary key on the master table) is of
type Date/Time (MS Access). Could it be that fields of that type cannot be
used to make master-detail relationship?...

I'd be thankful if anybody could suggest what might be wrong.


I recommend using integers as your primary key(s).

Good luck,
krf


.

Relevant Pages

  • Re: Master-detail dont work??? (MasterField type Date/Time)
    ... the master table is shown OK; ... a primary key there) ... type Date/Time. ... Are you modifying any of the TadoTable properties of the master or detail at ...
    (borland.public.delphi.database.ado)
  • Master-detail dont work??? (MasterField type Date/Time)
    ... the master table is shown OK; the detail grid is empty. ... set the MasterField to the field Timestamp, which is primary key in the master table and is present in the detail table ... The field tht links the tables is of type Date/Time. ...
    (borland.public.delphi.database.ado)
  • Re: Search Form - Take 2
    ... While in Design mode, highlight all of the fields you want to include in the ... selected fields to the primary key. ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
    (microsoft.public.access.gettingstarted)
  • Re: Search Form - Take 2
    ... selected fields to the primary key. ... description column in Recommendations or Accomplishments you'll have some ... as its due to the fact that the columns in master allow Nulls. ... well enter the same 'keyword' slightly differently, ...
    (microsoft.public.access.gettingstarted)
  • Row cannot be located for updating
    ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
    (borland.public.delphi.database.ado)