On Wed, 2009-12-02 at 13:20 +0100, Michael Hasselmann wrote:
Am Mittwoch, den 02.12.2009, 22:36 +1300 schrieb Andrew Ruthven:Hi Michael, Thank you for the prompt response. I'd managed to get that far, but now, can you make the Day field in the "remote portal layout" a drop-down list showing the Day's defined in the Day table?I wasn't sure how far you got but it's good to know that we look on similar results now.
Yeah, no worries.
If I: 1. Right-click on it in details view, 2. Choose "Layout" from the context menu, 3. Highlight "field: days::day" and click on Formatting, 4. "Select Use custom formatting" 5. Go to Choices tab 6. "Choices From Related Records" I can't see the "Day" field in any of the drop-downs.odd, I just tried with my example file, and I could select a "DaysID" (display name of avail::days_id). Perhaps that's because I made an explicit avail::days_id to days::day_id relationship in the availability table.
I can see avail::days_id, but that is the ID of the day, not very helpful for people.
However, I can't get the days combobox inside the "remote portal layout" of the people details view to work. That is, when I click on a day field in that column I can briefly see a combobox appearing but I cant make a selection. I can't remember having seen that feature in any of the Glom example files though. I am quickly going to summarize your use case, from my point of view: 1. Have a people table and a days table with a N:N relationship represented by a common join table, avail (with additional fields for start/finish time for a given name and day). 2. Display the joined view of people and days in the people details view, using a remote portal layout showing avail. 3. Allow editing of records via the remote portal in the people details view, which shows as a triple of (days::day, avail::start, avail::end). On editing records in the remote portal it should not be possible to select a day that does not exist in the days table.
Where days::day should be a drop down combo box box of allowed values.
Correct.
--
Andrew Ruthven, Wellington, New Zealand
At home: andrew etc gen nz | linux.conf.au 2010
| Follow the signs. Visit Wellington!
| http://www.lca2010.org.nz
Attachment:
signature.asc
Description: This is a digitally signed message part