My Assistant
![]() ![]() |
|
|
Jun 21 2007, 09:45 AM
Post
#1
|
|
|
New Member Posts: 11 |
Hey there, this is my first post on utter access so i hope someone can help!
Currently i have a regular form set up. with fields: itemnum, name, quantity and unit cost (this will be my hardware records). There will be multiple records with these fields, which is fine. But i also want to put another record on the form. "connection" whether it be cable, dsl, 56k, ect. I only need to display this ONCE since there will only ever be one connection at any given time. It will have the following fields: capacity and price. The reason for this is that i need to add the total cost for hardware and connection in the end. can anyone lend a helping hand? thanks in advance! -L1Nt |
|
|
|
Jun 21 2007, 10:02 AM
Post
#2
|
|
|
UtterAccess Ruler Posts: 1,122 From: Mississippi USA |
If I understand what you want correctly try this. Relate the hardware records with the connection records. Have the hardware table have a foreign key to the connection table by its key. Then create a query to pull from those two tables and create the form from that query. That should do what you want.
|
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 12:37 PM |