|
-
Oct 6th, 2008, 01:21 AM
#1
Thread Starter
Lively Member
Access 2003
I hope I am in the right place. I need some help in creating a database using Access 2003. If this is the right place, than here is what I am looking for.
I would like to create a table with one column named "Title". I know how to do this.
I would like each title to have an unlimited number of time, notes.
What I mean is, if I have 3 titles in the main table.
"Title"
Batman
Superman
Spiderman
I would like to have the option to be able to click on a title and have an unlimited number of notes to add. Such as ...
Code:
"Title"
Batman
|
--- "Time" "Note"
00:00:00 Start of movie
00:20:00 Batman gets in batmobile
00:30:00 ... etc.
... ... etc.
Superman
|
--- "Time" "Note"
... ...
Spiderman
I have a little trouble understanding what I would need. I was thinking 2 tables, but I am not sure what other columns I need, such as ID column and foregin key and etc. If someone could help me with this I would appreciate it. I am using Access 2003 and I will be creating the interface in VB .Net 2008 Express, so I am sure I will have more questions to ask.
Also, what is the most lengthy note I can add. Sometimes I could use the option to add a few paragraphs. What data type would I use.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|