multiple rows in relationship

Archived from the Xataface Users forum.

bjlockie — Sun Jan 23, 2011 12:37 am

I’m having trouble adding multiple rows to the SupportedFirmware table.
I have 3 tables:
router
RouterID

firmware
FirmwareID
name

SupportedFirmware:
FirmwareID
RouterID

The router_support/tables/router/relationships.ini contains

[SupportedFirmware]
firmware.FirmwareID = SupportedFirmware.FirmwareID
SupportedFirmware.RouterID = “$RouterID”

I want to be able to select multiple rows from firmware and insert them into SupportFirmware.
I tried
[SupportedFirmware]
widget:type=”advmultiselect”
a lot of places but not where it works.

The app is online:
http://lockie.ca/router_support/

I found a bug.
Go to: http://lockie.ca/router_support/index.p … edFirmware
Click the “remove” button but don’t select a record.
The dialog says “copy”.

---

shannah — Sun Jan 23, 2011 11:01 am

You could either use the grid widget or the checkbox widget for this. In either case you would need to include some extra directives so xataface knows your intentions. E.g at least transient=1 and relationship=SupportedFirmware