I've been trying right clicking in the Navigator. This allows me to add a new form but I only end up with a sub-form called Standard that has no table linked to it and no fields.
First question: Do you want the values you select from the lookup tables to be saved in the album table? That is do you have ArtistName, format, and type fields in the Album table? If so, you don't need to to have subforms.
LJ Bettona wrote:I have the keyfields from the three reference tables in my album table and am assuming that when I select an artist, etc from the combo boxes, the ids will be saved, not the names. That's why I think I need sub-forms, but I could easily have misunderstood what I was reading in Getting Started and the NeoOffice guide.
LJ Bettona wrote:The problem now is to get the slave field onto the form. I'll go back to Adding a subform and see where I get following that.
Ah, so you want be able to lookup the Artist name in the Artist subform, but enter the ID number for that artist in the Album table. Is that right?
LJ Bettona wrote:Hi,
But - I've had an idea. Suppose I used the Artist's name as the keyfield instead of some arbitrary self generated number? Then, the name itself could be saved on the album table, and the relationship would be between artist name on both tables. It's not the best way to design a database, but it may be the way this system works best.
This makes a very small artistname table - just the name field 'cause I'm not into DOB and biog stuff, just who's performing.
If this works, then the same would hold for the other lookups - single field tables. But it would guarantee that the input is consistent and accurate. And that's the objective - both for this one and for the book list and DVD list I want tobuild. They're all basically the same database, just field names will be changed.
LJ Bettona wrote:I'll work on your instructions later today and see how far I get. I'm interested in your reference to more than one main form on a form. I'll reread the NeoOffice tutorial.
LJ Bettona wrote:Thanks for the help.
LJ Bettona wrote:Now, when I enter a CD, the drop downs display words, but the ID is what is stored. Minimizing the storage space.
Don't ask me how the storage happens. Probably through the relationships I built. Do you know, Lorinda?
Users browsing this forum: Villeroy and 4 guests