One-to-many relationships - many is uneditable

  • Thread starter Thread starter a.t.brooks
  • Start date Start date
A

a.t.brooks

Hi
I have a simple DB with a one-to-many relationship. I have created
Datapages for both the main and the many tables, then hyperlinked to
the many DAP from the main DAP. However the many DAP appears to be
uneditable. Why is this?

Originally the tables were accessed through forms with the many form
appearing as a subform in the main form, but DAPs don't support
sub-forms.

I have included the fields used to link the tables in both DAPs. The
field in the main page is a PK autonumber.

Thanks in advance
Tony
 
DAP (Data Access Pages) are only usable in Access
- not thru a FrontPage database connection

Suggest you ask in an Access Newsgroup if using DAP in Access

PS
In any relationship definition if you select Enforce Integrity it will prevent you editing a table/record without editing the
primary record controlling the relationship

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi
| I have a simple DB with a one-to-many relationship. I have created
| Datapages for both the main and the many tables, then hyperlinked to
| the many DAP from the main DAP. However the many DAP appears to be
| uneditable. Why is this?
|
| Originally the tables were accessed through forms with the many form
| appearing as a subform in the main form, but DAPs don't support
| sub-forms.
|
| I have included the fields used to link the tables in both DAPs. The
| field in the main page is a PK autonumber.
|
| Thanks in advance
| Tony
|
 
Back
Top