Full Version: Displaying a field only once
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
L1nt
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
cdavidsn
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.