By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Subform Creation

P: 4
I need a big favor from you guys. I need to create a DB for cost savings based on a year to date situation. These are the fields that I have:


Person Reporting = Text (This can be an individual table for a dropdown field.
Category = Text (same as above)
Savings Type= Text (same as above)
Title = Text or Memo ( this will be use for more description.)
Action Taken = Text
Date Savings Starts = date/time (the format needs to be MMYY)
Attachments = (to be able to put attachments for detail information)

Second Table:

Fiscal Year = Date/Time (field has to be 2 digits)
Monthly Amount = Currency
Yearly amount = currency.

I need to create a form and a subform, but I'm having trouble putting all together. I'm able to create all the tables, but I can have them talk to each other. Any help will be appreciated.
Apr 10 '09 #1
Share this Question
Share on Google+
5 Replies


P: 4
Nobody has a clue on how to do this???? (*_*)
Apr 10 '09 #2

RuralGuy
Expert 100+
P: 375
Welcome to Bytes Cachita. I suspect a number of readers have ideas on how to proceed but this sounds an awful lot like a school project. We are reluctant to pitch in here unless the poster demonstrates they have put a lot of effort into the project. I doubt anyone knows what you really mean when you say
"I'm able to create all the tables, but I can have them talk to each other."
Apr 11 '09 #3

missinglinq
Expert 2.5K+
P: 3,532
You also need to take the time to read the thread http://bytes.com/topic/access/answer...ing_to_a_forum, paying particular attention to the topic "Give a clear title to your question ."

Linq ;0)>
Apr 11 '09 #4

P: 4
My most sincere apologies for not reading the instruction on how to post and for not following the guidelines. I will keep that in mind for future questions. I guess everybody think that their case is unique although others might have the same situation. Thanks to those that responded.
Apr 11 '09 #5

NeoPa
Expert Mod 15k+
P: 31,709
Cachita,

That wasn't trying to put you off. That was a prompt for you to show us where you're up to on the problem, and possibly clarify exactly what you need help with.

If it is a set problem, it is better to indicate that, then we know to be more careful.

Remember, there are various wizards that will help you to get started on some of these basic setups.

PS. I changed the title for you.
Apr 13 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.