recursive relationships? (1 Viewer)

[casey]

relationships???

Hi everyone,

I'm trying to implement a relationship and I’m getting descriptive parent data (Type, Description, DefaultPrice, DefaultCost) showing up on the subdatasheet where I would like the same fields to show for the child’s data instead.
A Product can have one or more Components (other Products)
(i.e. a Computer System can have Mouse, Monitor, CPU and so on...)

Table 1 Products
Fields (ProductID(PK), Type, Description, DefaultPrice, DefaultCost)
Instance:33, System, Taipan1202, $2300, $1900
Instance:22, Mouse, Logic, $17, $15
Instance:11, Monitor, 15”, $399, $350

Table 2: Components
Fields: SystemID(FK), ProductID, Qty
Instance: 33, 22, 2
Instance: 33, 11, 1

Desired Results:Subdatasheet form to show the child’s descriptive data
Datasheet: 33, System, Taipan1202, $2300, $1900
Subdatasheet: 22, Mouse, Logic, $17, $15
Subdatasheet: 11, Monitor, 15”, $399, $350

Actual Results:Subdatasheet form showing parent’s descriptive data
Datasheet: 33, System, Taipan1202, $2300, $1900
Subdatasheet: 22, System, Taipan1202, $2300, $1900
Subdatasheet: 11, System, Taipan1202, $2300, $1900

Can anyone assist me on this one?

Can the subdatasheet display Type, Description, etc. for the components instead of the parent Product?

HTMS

 

[casey]

Forget it.

Thanks for anyone who spent any time on this.