The table relationships must be set in the Relationships.The linking table must have a multi-column primary key, and both columns must be integers.The principle tables must have an integer primary key that is set to AutoValue.To answer this in a little more detail, as it comes up early on Google search, please refer to the following video of creating the movies.odb file from scratch: I belive the answer is somehow using SubForms, or maybe some SQL syntax I'm not familiar with. I've tried Google'ing all possible keywords and I've come up with nothing applicable to my case. A preferred setup would be a list of keywords (dynamically linked to the Keywords table of course) in the previously mentioned form I've already created with a check box in front of each keywords The number of keywords is finite (probably 5-15) if that matters. That is, I want the user to be able to view and choose which keyword(s) belongs to the article currently being viewed in the form. My problem is how to include the relation to Keywords in that same form. Then I created a form (for the user using the database) using the 'Design view' in Base and linked to the Articles table, which works fine, and allows me to view, edit and created rows in the Articles table. Just a basic, classic, example of a many-to-many relation.
I have a Relations table with columns: ID, ArticleID, KeywordID I have a Keywords table with columns: ID, Keyword. I have an Articles table, with columns: ID, Title, Content, etc. I chose 's Base (version 3.1.1) because it's free and should be more than enough for this case. I'm doing a small relational database, to be used by one person on a single computer.
0 kommentar(er)
