UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Displaying a field only once    
 
   
L1nt
post 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
Go to the top of the page
 
+
cdavidsn
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 12:37 PM