Ask Your Question

Tait's profile - activity

2018-05-10 21:51:14 +0200 received badge  Famous Question (source)
2017-11-18 01:05:14 +0200 received badge  Notable Question (source)
2017-10-15 14:41:31 +0200 received badge  Popular Question (source)
2017-10-10 03:15:05 +0200 commented answer Using List/Combo Boxes in a datasheet subform for data entry

In all the tutorials I've watched, the bound field had not yet been clearly defined. Thank you for your time and experie

2017-10-10 03:11:37 +0200 marked best answer Using List/Combo Boxes in a datasheet subform for data entry

I am trying to set up a form in a database for data entry. The data is being used to create receipts for customers and tracking overall sales. The Tables and Relations are as follows:

Receipts:

  • Receipt ID (Primary)
  • Transaction Date
  • Name

Sales:

  • Sale ID (Primary)

  • Receipt ID (Foreign)

  • Product ID (Foreign)

  • Unit Price

  • Quantity

Products:

  • Product ID (Primary)
  • Department
  • Product Name
  • Product Description

I would like to create a form with the Receipt fields above a datasheet subform containing the following fields:

Data Entry Form:

  • Product Name
  • Product Description
  • Unit Price
  • Quantity

Where I am getting hung up is using a list box or combo box within the datasheet with a dropdown to choose the product name. After choosing the product name, I would like it to update the Product ID on the Sales table as well as showing the proper Product Description for the Product chosen. I have managed to add a list box or combo box in the table, and had it show the right list, but it will not update the Product Name or Product Description. Is what I am trying to do possible? If so, how would I go about doing it? If not, what other methods could I follow for a similar result. My ultimate goal is to be able to enter all the linked information from one form. Then create a button that saves the record and brings up a corresponding Report with all the information in place.

I have a sample database, but it won't let me attach it because I have no points, and this is my first time on one of these forums.

2017-10-10 03:11:37 +0200 received badge  Scholar (source)
2017-10-09 17:38:49 +0200 commented answer Using List/Combo Boxes in a datasheet subform for data entry

Thank You. I believe I had misunderstood how the bound field operates, and was trying to store the description instead o

2017-10-09 05:24:52 +0200 asked a question Using List/Combo Boxes in a datasheet subform for data entry

Using List/Combo Boxes in a datasheet subform for data entry I am trying to set up a form in a database for data entry.

2015-10-04 22:27:41 +0200 received badge  Famous Question (source)
2015-10-04 22:27:41 +0200 received badge  Notable Question (source)
2013-09-27 19:01:35 +0200 received badge  Popular Question (source)
2013-09-02 23:39:30 +0200 asked a question How do I insert a picture placeholder in a template file when using Draw?

PS. I am using a portable version of LibreOffice and the drop down insert menu does not show "other" as an option.