Results 1 to 2 of 2
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Is it possible to create 1 form that delivers data to two tables?

    I've got three tables that deal with our part numbers as the primary ID. One table is a 1:1 relationship with a list of manufacturers. This table also has a relationship with a components table that shows component type and sub-type, again based on our P/N. There is also a third table, in where I list a 1 to many relationship showing the part number and all the manufacturer's and their part numbers.

    What I would like to do is take the form I created for adding a new component to the first table and expand the form I currently have, so that some added fields could enter the data into the second table. Is it I possible and if so, how would I go about doing this?

    I will also say, I DO NOT program well, so if I need to add verbage to a macro, that would be step-by-step process for me.

    Thank you,

    Rebecca

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I am not understanding your description of your tables perfectly. Considering my past experience with parts, manufacturers, and part numbers, you will want to attempt to edit a single table at a time from within your form.

    To facilitate this, you can employ Combo Box Controls. A combobox can programmatically display relative records in a subform. As an example you could select company B from a combobox and then all of company B's components would display in a subform below. You could allow a user to add or edit a record within the subform.

    Since the list of Companies may also need to be edited, you can make allowances for this. The main idea is to bind a single form to a single table.

    So, the short answer to your question is, yes. It is possible to do just about anything. However, just because it is possible does not mean you should. Your application should manage constraints on your data. So, make your forms do specific things.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to create a query when one of the linked tables has no data
    By SagarHussain in forum Database Design
    Replies: 3
    Last Post: 12-15-2015, 09:48 PM
  2. Sum Query Delivers wrong results
    By rbf in forum Queries
    Replies: 5
    Last Post: 03-30-2013, 03:18 PM
  3. Replies: 10
    Last Post: 07-31-2012, 11:02 AM
  4. How many Tables to create for data
    By cpill in forum Access
    Replies: 3
    Last Post: 04-26-2011, 05:50 PM
  5. Replies: 9
    Last Post: 12-17-2010, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums