1

I am trying to develop a timecard form. The fields are ID, task, date, start time, and stop time. I want to create the form as a datasheet. I don't know the specific name for this, but I want it to look like a typical spreadsheet.

The thing I'm stuck on this that I would like the "task" field to be something like a combo box that can look up values from another table. Anyone know how to do this?

Improve this question

1 Answer 1

Reset to default
1

Detailed instructions with an example file are at https://ask.libreoffice.org/en/question/143186/how-to-use-user-selected-value-from-combobox1-in-combobox2-select-statement/?answer=143231#post-id-143231.

Many of the changes are made by right-clicking on the column header of the table control.

edit column

Improve this answer
2
  • I appreciate it, truly, but those instructions are completely beyond me. And it looks like they are trying to do something more complicated than what I am trying to do. From your picture, I was able to convert the column to a list box. But now the list box comes up empty. I can't figure out how to convince it to find its values in the "task" table. I've clicked every control and field that I think could possibly be relevant. I've worked with list boxes several times, but this seems to be different. Any ideas what I should do next? Thanks again!
    – bob.sacamento
    Apr 5, 2018 at 14:36
  • Cancel the alert! Wasn't as different as I thought. Figured it out from previous examples. But I got the conversion to a list box from your pic. Thanks for that!
    – bob.sacamento
    Apr 5, 2018 at 14:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .